help Extracting data from multiple excel work books

A

Apples76

As part of my job i am approving final accounts for several projects, to
which i have created a DB ease this task.

The DB records all requests and total ammounts for two parts of the project
Cost 1 Acquisition cost 2 Build.

I have now been asked to report back on a single build item, and i am
wondering if it is possible to extract this data from each FA request (an
excel file). the data will be in the same location in each file and each file
has a different name but is located in the same network folder.

could some one please help.


Thanks

i have over 100 to check and
 
Top