Macro to consilidate multiple sheets with different format into a New Excel File

[petes]

Guys -

I have one excel file with multiple tabs. The data in each tab varies. I mean, row heading and column heading in each tab might be different which does not matter.

I just need to merge all tabs into a New Excel File in a single sheet.

Also, the location of source file should prompt instead of hard code in the macro


Appreciate your help!!

Thanks..

 

[Andrew Poulsom]

There's an example here:

Merge data from all workbooks in a folder

 

[petes]

This helps..but does not have specific to sheet merging into new worksheet..

Any thoughts??

 

[Andrew Poulsom]

There's more code on that site that will probably help you (under Win Tips, Copy/Paste/Merge).