Hi,

I have 7 spreadsheets in one workbook filled with data in columns B:T with a varying number of populated rows within each worksheet. I am looking for a macro that will copy data from the populated rows in one worksheet, paste them into a 'summary' worksheet, then move onto the second worksheet and copy data from the populated rows and paste again in the 'summary' worksheet, below the data that had just been pasted. Need this macro to run through the copy paste process on all 7 'data' worksheets and paste into the 'summary' worksheet.

Thanks for any help