Consolidating data on muliple sheets to master

I have a workbook that is created using queries in Access. The data exports to different tabs depending on the query that is run. In this case I have 5 queries equalling 5 different excel worksheet tabs all in the same workbook.

I have a macro set to format the main sheet and delete the remaining tabs but I can not figure out how to consolidate the data prior to deteting.

The format is the same on all of the sheets
Sheets 1 - 5
A - F contain data
Rows will vary depending on month.
There can be no empty rows in my data on the main sheet.

I can figure it out if the rows were set to specific numbers but this needs to vary by month...

Can someone please help me identify how to find the active rows on sheet 1 and paste to the main sheet (XAA) then the active rows on sheet 2 and paste this in the first empty row on the main sheet?

Got It!

I was trying to make it too difficult....

Please Login or Register  to view this content.