Macro to reorganize and collect data from multiple workbooks

[bobfor1]

I'm sending out an excel file with a survey to 300+ individuals and was wondering if there was a way to reorganize and collect the data automatically.

I've attached a sample workbook with an example survey.

The data points are located at different sections of the survey and I was wondering if there was a way to automatically reorganize all the data in a single row (example is located in the example output worksheet) and collect it from several workbooks.

The survey that was sent out only includes an instructions tab and the survey tab.

Also not sure if its possible to collect the filled out survey worksheets and dump them into one workbook. I ask this because in the actual survey there's some additional fields that have lists of info that individuals can add but won't be comparable since they can potentially add an infinite number of things.