URGENT *** Need to Compile Data from many different workbooks into one

Hi,
First post here. Need help!!

So,
What I'm doing is compiling demographic information. I have a spreadsheet of 500 or so addresses. I take those addresses, plug them into an online software called Pcensus, generate reports, and then each report gets downloaded into a workbook, each as a separate worksheet. Screenshot Excel.jpg

Then, I created a worksheet with 6 heading that reference the relevant cells from the sheets (reports) in the workbook.

The end goal is to get the info from that sheet into the master spreadsheet of addresses so it's all in one place. Then I could rank the information and narrow down my list.

Please let me know if I can provide any more details, descriptions, or screenshots to assist.

What I really need are clear, concise instructions to repeat so this work can be passed off.

Thank you!