MACRO QUESTION

[Eddy Stan]

Can anyone give me a macro to consolidate worksheets of different books.
workbooks from locationA.xls LocationB.xls, LocationC.xls are in one folder.
having sheets : sales, collection, advances... (sheet names unique, data
starts from row 7 in all sheets in all workbooks)
I want to have one file to show sales, collection, advance - data from each
location pasted one below the other.
I would like to have the macro in consolidation file and I would like to
keep the workbook names in sheet1 starting from column a row 3
pleeeeeeeeeeeese help me.

 

[Roger Govier]

Hi
Take a look at the macros that Ron de Bruin has set up on his site.
http://www.rondebruin.nl/copy3.htm
That should give you a good start.

 

[Eddy Stan]

Wow Roger, you are great.
First I am trying to work on the examples then I will try with my live data
thanks a million. I will be back...soon
I have to merge 70 files of 8 sheets which will take a week to do accurately.