Gathering information from multiple Excel files, onto a singleExcel MasterSheet.

Hello,

Im new to the community, so, go easy on me.

Ok, heres my situation...

I around 200 seperate excel files containing information about my companys employees, one excel file per employee in a folder. (containing: Name, address, age, etc.)
Now I need to make a One condensed master list containing some information from each sheet into a horizontal, grid type master list.
I have the master list made, i just need to know if there is an easier way to transfer all of this information from each individual excel file to the master list excel file, rather than having to enter it manually.

I've attatched the master list. "May 2012 Bi-Annual Inspection Report"
I've attatched a sample of one of the 200 other detailed files. "1111 SAMPLE"
Hopefully you understand and can kind of see what im trying to do.

Thanks,

-Logan

Thanks!

I'm not very profficient in Microsoft Excel.
I think I understand modifying this code, but,how/ where would I go about inputting this code?