VBA Code to read Files

Hi,

I have a pretty time consuming project due tomorrow and I'm looking for some guidance on the fastest way to pull this off. I am sending an excel file containing four tabs (Block 1, Block 2, Block 3, Block 4) to 20 folks. Once they fill in scores, each of them will email me their files back. I have created a "Master" file for myself and the plan is to copy/paste the data 80 times (4 tabs X 20 attendees). I know there is an easier way to do this, but I don't know much VBA code. Is there a way I can dump all the files in a folder and have excel read and populate the data on my "Master File"? All the data is the exact same on all 20 spreadsheets with the exception of the scores and names of course. I have attached the template going to the attendees and what my "Master" file should look like. Any help is greatly appreciated.

Niki

Hi,

Yes, please I am still in need of a solution. I was able to buy myself an additional day.

I can't thank you enough for all your help!!!

I copy/pasted the VBA code into the Master Data File, but when I try testing nothing actually happens. Can you please let me know what I'm doing wrong.

Thanks
Niki

Try renaming the files as Such:

Javed A.xlsx‎
Mel T.xlsx‎
etc....

The macro provided by p24leclerc worked for me.

Hope that helps,

BigDawg15

Thank you!!!!