Combining selected sheets only in one "all data" sheet

[tabfri]

Hi there

I would like to combine specific sheets into a Master Data sheet.
I have worksheets from the years 2000 up to 2010 and want to combine only these in my Master Data and not all the other worksheets (worksheets where I have my calculations in etc.).

I would be glad if you guys could help me.

Thank you.

Cheers

[Norie]

What are the names of the worksheets you want to combine and how do you want to combine on the master data sheet?

[tabfri]

The names are 2000; 2001 ... and so on ... up to 2011
I just want to copy the first table from 2000 and then put the data from 2001 directly under it.
The second copied worksheet, however, needs to start at the second row as the first one contains the title, which I would only need once.

And it needs to exclude worksheets the other worksheets.

Thank you

[Norie]

Try this which assumes you actually have a table on each worksheet.

Please Login or Register  to view this content.

[tabfri]

Perfect,

Thank you a lot!!
That really helped!