Extracting data from multiple workbooks and perform calculations

Hello, I have more than 200 Excel workbooks which are all formated according to 3 different templates.    I extracted the list of all the workbooks in the folder and created a table in "MasterRegi...