Build a 10 column Spreadsheet to Extract data from Word Doc 10 data fields (Coding excel required)

I am looking to extract data from completed inspection and Audit log sheets located within a specific folder on my desktop called "Inspections and Audit" into an excel spreadsheet The Inspection Form has 10 Questions - and the answers data will need to be transferred into a Spreadsheet that has 10 columns each new completed form should produce a new line I want the spreadsheet to extract data directly from the word documents within the folder, without opening the individual forms by clicking a button within the provided spreadsheet. The spreadsheet and word template are attached. Its the coding to make it automatic that is required