I have a folder full of a number of different Excel files that are utilized by another spreadsheet for summary purposes. As I add new Excel files, I would like to have a way to automatically gather the data in the summary spreadsheet without having to manually go and enter the new filenames.

Is there a way to automatically populate data into the summary file from, for example, all files in a given location?

Thanks,

J