How do I lookup large number of workbooks (by filename) for data?
 

I would like to create a master workbook that searches for files in a certain
place and retrieve part of those data. The filenames would change from time
to time (by product name) and I would like those files to be the source file
objects. This way I avoid entering information twice.

KT