The external file will be open.

The sumif will be used to bring the data into a master sheet, and then the formulas will be set as values.