Advanced Excel Q - Fetching Cell Values from Multiple .xls files
 

Say I have a folder with 1000 excel files in a standard "form" format, and each has different values in the form.

Is there any functions or VBA I can use to automatically fetch a particular cells values (e.g. A5, C8..etc) from all 1000 excel files? (and consolidate them into a list of values on one spreadsheet)

hmmmmm no one has any clue? anyone knows any good excel forum which might give me the answer?

Or this probably can't be done with just excel?

You might be able to use vlookup:

http://en.allexperts.com/q/Excel-105...ple-sheets.htm

you can link it- but it would not be efficient for for 1000 .xls files.

have you considered a database instead?