Excel Forum Solution.xlsx

Attached is a base file

What I am looking for is a way to change the formulas in section F12:G29 to reference the file in cells F37 & G37 respectively. I know I could build the whole thing out of CONCATENATEs then copy/paste special values and add a "+" in front to make it a formula again, but there has to be a better solution.

Will need to do this multiple times a week linking to other spreadsheets - The formulas will stay the same linking to the same spot in other sheets.