Extract specific cells from multiple files in folder

[mittmo]

I'm new to macros and have a folder of about 1,000 files. It's basically a form in Excel and I'm looking to extract specific cells from every file and place them in another file acting as a master list. For example, each file has the same sheet name and I want Customer Name (B2), Date (G2), Salesperson (B6), Perimeter (C9), etc. to be in rows. I included a screen shot of both files.

 

[mittmo]

Clearer screenshot...