Automate Information Importing?

[ARF_Intern]

Hello everyone! Thank you so much for helping all the noobs that only sign up to ask for help then go away forever because we're too clueless to help hahaha. It means a lot (: to me at least.

Well, before I get all emotional...

I'm at an internship right now and have a question about importing workbooks.

There's supposed to be 20 companies that each get an excel template to fill out survey questions. I want to them aggregate all of the information from these excel sheets together in one master document.

Is there any way that I can just run a macro that will automatically extract the data from each of the workbooks and calculate the aggregated data? Manually opening each workbook and summing the data together doesn't seem very efficient.

I contemplated using something with the OFFSET formula, but these workbooks are just too massive (the template workbook has 8 tabs with at least 30 questions on each tab. So that's 30 rows minimum.

Maybe a macro that calculates all the worksheets in a certain tab range, then I just keep importing the sheets to one master document that automatically calculatesi t?

Maybe i'm thinking too hard? HAAHHAHA

I attached a copy of the file (removed pertinent data for security reasons).

What magic can ya do? Looking forward to your responses!