Merge several (hundreds) tabs in excel 2010 into one page

[eeanil]

How do I consolidate several hundred pages of excel data (sheets) into one -

they have the exact same headers,etc...

I have a macro that can do it for 5 pages . but it gets an error for doing more than that.


Please advise.

[davesexcel]

Lets see the offending code.

[jeffreybrown]

How about

http://msdn.microsoft.com/en-us/library/cc793964.aspx