Macro to import all data into Mastersheet

[Matt Lee]

Hello all,

I have a workbook with multiple sheets that are used as forecasts so they are updated on a weekly basis. I am looking to use a macro that imports all the data into a new - Master sheet. Any suggestions? your help would be greatly appreciated.

I have attached an example of the document! Please help!!

-Matt

[arthurbr]

Hi,
you'll find different possibilities at this site under Copy/paste/Merge examples

[Dom83]

Hi Matt,

This code will add a new sheet and paste the data from all other sheets (Note: this assumes that all sheets are in the same format).

Please Login or Register  to view this content.

Cheers,
Dom

[Matt Lee]

Now Im just curious, say the sheets are continually being changed and added to, they are forecasts. Will I have to run the macro over everytime a *NEW* forecast is added to one of the sheets?