All data of many sheets in one sheet

[Pampos]

I have 50 sheets with rows A to Z full completed untill A100 to Z100...

If there an easy way to have a 51st sheet that have all that data, with out copy them one by one? So the 51st sheet must have rows A to Z full completed untill A5000 to Z5000... (50*100).

 

[vletm]

Yes ... with Macro
, but
why to do so?

 

[Pampos]

I need to copy all that data at once.
How with Macro?

 

[vletm]

Pampos
Q: Why... ?
A: I need ... okay!

Sample Macro:
Copy Macro 'Do_It' from Sheet1's code to Your file and run it!
It works ... if You have file as You have written!

 

[Pampos]

Thank you very much! Is working!!

 

[pecoflyer]

This addin will also help a lot http://www.rondebruin.nl/win/addins/rdbmerge.htm