Excel Macro Help

[n0ra]

I have several worksheets in a workbook.. i need a macro that could like copy/extract all the data from these worksheets and have them all together in one main worksheet... at the same time, i need to make sure that any new data inserted in any of these worksheet is copied into the main sheet too...

any help is appreciated.. 10q :wink:

 

[Derek Brown]

You may not need a macro - have a look at the Data Consolitaion feature of Excel.
You will find it on the Tools | Consolidate menu. Make sure that you select "Create links to source data" if you want the created sheet to be updated automatically.