Hi JB

Start here for a code solution
http://www.rondebruin.nl/copy3.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl


"jb" wrote in message ...
We have 160 spreadsheets of data that need to be entered into one spreadsheet
-weekly.
Actually, there are 40 locations with 4 spreadsheets each, same setup at
each location. There are about 100 fields of data that we need from each
location.
We pull the spreadsheets in and can then hopefully merge this data into one
spreadsheet. The end result would be a spreadsheet with forty rows with 100
fields of data.

What do we compose that we can use weekly to automatically merge the data
from the 160 spreadsheets into one spreadsheet??

Thanks for advice. jb