Loop through tabs in a workbook to consolidate data

Hello,

I was hoping someone could help me out? I put together the attached file and code to consolidate information. The macro is running through the tabs and pasting them to the tab I specify but it is not stacking the data to consolidate all of the information to one tab. Instead it copies each tab and pastes completely over the data each time. I want it to copy sheet1 and paste it to sheet 30. Then copy sheet2 and paste it to the bottom of sheet 30 below the area it just pasted for sheet1. Any help is much appreciated.

Please Login or Register  to view this content.

The macro should work through however many sheets are in the file. Could be 2. Could be 100.

Hi Amartin,
try it

Please Login or Register  to view this content.

Damn your awesome. Thanks! Sorry to bother you but is there a way to insert a column on each tab before consolidating where it copies the 4 digit BU - property name down the column? Example in tab sheet1 cell b8 it says 2000 - Apache Mall. Is there a way it would insert a column in A and then copy that down to the bottom of the range in column A and then copy the data over and continue to do that through all of the tabs? It would make it easyer to clean up all the data.

Not sure, but maybe this

Please Login or Register  to view this content.

or attach a small sample (2 or 3 sheets) with the desired result.

you rock. Thanks!