Need Macro to combine multiple worksheets into one

Hi all,

I have a workbook with about 30 worksheets, each with the same column headings but with a different amount of rows every month. Every month i have to consolidate each worksheet into one 'summary' worksheet (which is essentially me just copy/pasting all the rows in each worksheet under one another, without the headings)

I managed to find some VBA code online which combine all the worksheets into one, although i have a number of worksheets in my workbook which i need to exclude from the macro. I also only need the headings once at the top.

I've attached a sample workbook - so for example i need each of the worksheets combined into the 'Summary' worksheet, while excluding the tabs i don't want.

Any help is greatly appreciated!!

Thanks!!

It wasn't clear what the limiting factor for the excluded tabs was so I just based it precisely on your example workbook:

Please Login or Register  to view this content.

Hi Robert,

The code worked great! but i need one small adjustment if anyone can help.

When i run the macro it removes the formatting of the original worksheet - which messes up some of my data.

For example, in the attached workbook, column "B" has product codes in a specific format in each of the individual tabs (Ontario..Quebec..Atlantic..etc.)

But when i run the macro it removes the formatting and pastes the product code as a date in some instances... Is there a way to paste what is directly in the cells of each tab - and not just the values?

Thanks again for your help!