将标准模板文件中的数据编译为主电子表格

Basically, I have a large list of excel files which have a standard template which is sent out to people to fill out. Think of it as a form. It is a mix of numbers and words and I would like to sort this and file it into a master spreadsheet, with some values going in different workbooks. The file which people filled out is not in the same format as the master spreadsheet (which means I can’t copy and paste the chunk into the mastersheet). Basically, I have a large list of excel files w