Help Extracting Data From Excel Workbooks

Hi, 

I'm an excel amateur and have task I need help accomplishing some advice. 

My company uses an excel workbook to produce custom quotes for our clients. Each workbook individually is saved in the individual quote folder. I need to pull specific cell data from 2 worksheets from each quote workbook into a single workbook. This data isn't saved in a table format. There are probably 300-400 workbooks I need to extract this data from, but am really looking to work with 100-150 of the workbooks to start. 

The data needed in each workbook is not saved in a table format, but in random cells on the 2 sheets. Here is the list of the cells I need information from:

What would be the best way to try and consolidate all of the data from those cells from each quote workbook into one master workbook with set table columns. 

I'm not sure what other information is needed for a possible solution. But, feel free to ask any questions and I will answer the best I can.