Maybe Ron's site has something you can use

http://www.rondebruin.nl/tips.htm

it's under Copy/Paste/Merge examples


--


Regards,


Peo Sjoblom


"smonsmo" wrote in message
...
I have a folder (J:\COMPANY NAME\2007 Contracts\JOBS BY MONTH\SEPTEMBER)
that
contains all the contracts scheduled for a certain month. What I would
like
to be able to do is grab the information found in these cells, c1
(Customer
Name), b34 (Job Lead), w29 (Job Dollar Total) and u3 (Date Job was
Completed). Then compile a report on another workbook. Any help would be
greatly appreciated.