copy completely same tables into one sheet

[Svea]

Please hlep me with following: I have 50 sheets with completely same
columns. On every sheet I have 20, 50 or 500 rows. I would like to have
all data in one sheet. I have to copy select all rows in each and every
sheet and copy it to another sheet, 50 times...

Do you know any automatic way to do that?

 

[Barb Reinhardt]

You'd have to use a macro to do this. You may be able to get something from
here

http://www.rondebruin.nl/copy3.htm#header

but I suspect it would need to be modified for your application.

 

[Svea]

Thank you, I will surely try.
Any other ideas?

So I have 100 invoices all placed in one woorkbook but one differen
sheets. Their columns are same. I would like to have them in one shee
without copying each sheet manually.

Thank you in advance

 

[Svea]

Can you give me some other ideas?
Thank you so much