[Ferra]

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)

[Ferra]

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?

[Jsunu]

You might be able to use vlookup:

http://en.allexperts.com/q/Excel-1059/Lookups-across-multiple-sheets.htm

[tiger_handheld]

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

[Vinny G]

have you considered a database instead?