Gather data from multiple excel files in mutiple folders

[Mark Ivey]

Hello,

I need some help to generate a macro that will gather data from mutiple
excel files (all named the same) that are all located in their own
subdirectory.

More explanation:

I want the user to be able to select one main directory for the month, it
contains daily subdirectories that each have an excel file named: "QC
Production Sheet". Within this file, they each have a worksheet named:
"Gqf44"

I would like the macro to gather all the information on these sheets (after
the user selects the main monthly directory) in each daily subdirectory and
copy it the the master excel file that will perform the overall summary.
Basically have it copy each worksheet into the master and name these
worksheets with the date that is entered in cell "C5" from the worksheets
that are being pulled.

Any help on this item is greatly appreciated.

Thanks in advance...

 

[Ron de Bruin]

You can try this
http://www.rondebruin.nl/fso.htm

 

[Mark Ivey]

Ron,

I think I can work with this...

Thanks a million...