Thanks, that worked beautifully. I have another question though. I have
folders for each month of the year. Within each folder would be all the jobs
that had been scheduled during the corresponding month. Is it possible to
automatically open all the files in the chosen month without being asked to
choose.

"smonsmo" wrote:

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.