Extract data from multiple workbooks into one data table

Hi,

I have approx 400 excel files which contain a variety of data but I want to extract 7 particular cells of data from each and create a simple table of this data in a new workbook (7 columns x 400 rows). Can anyone show me a quick way of doing this. I'm sure it can be done but I cannot find a simple solution anywhere.

All 400 files are saved in "C:\Documents\Data Extraction"

Cell references are as follows.

PIN - I10
Start Easting - D12
Start Northing - F12
End Easting - H12
End Northing - J12:K12 (Merged cell)
Safety Score - D128
Total Score - I129

Any help would be much appreciated.

Thank you dflak.

Sorry, I forgot to mention the data is on Sheet 2, renamed to "Pavement SAR"

Can the code be changed to look on sheet 2 instead? I would send a source file but they are quite large.