Greetings all,

I have been searching and have not quite found an answer for my project. I want to import data from multiple closed excel files into one master file that is open.
1. All files (source and target) will reside in one folder.
2. I would like to import from all files regardless of their name if that is possible.
3. I want to import data from cells A1:C40.
4. I want to import data to one sheet that will add the subsequent data below the previous.

Your help is greatly appreciated.

Ken