Copying data from several worksheets in one new worksheet

[Catalin]

Hello again

I'm getting reports in an Excel file with more then 30 worksheets. All of them have the same structure. I would like to add them all in one single sheet and to place the source "sheet name" in the last column.
All sheets have 12 columns with different number of rows (between 1 and 100). First row in each sheet is the header of the table.

It is posible any automatization?

Thanks and regards
Catalin

[rwgrietveld]

Catalin,

This is a very straight forward approach.
1) Make a sheet call "Summary"
2) put this code in a module and run it

Please Login or Register  to view this content.

[dcaraher]

There is an excellent add-in which I believe does exactly what you are looking for. Go to Ron de Bruin's website at www.rondebruin.nl/tips.htm.

Look for the excel add-in page and go to the add-in called "RDB Merge"

How to use it and instal it is explained on the website.

[Catalin]

Guys

For the meantime I would like to thanks in advance. I will come back to both of you.
Thanks and regards
Catalin

[Catalin]

Thanks a lot. You save me from spending time working with "copy paste" for each sheet (38 in total).

Thanks again.
Catalin