Well, I don't know what your workbook "MasterList.xlsx" looks like, for example:
While both workbooks are open enter in a cell:
=[MasterList.xlsx]Sheet1!A1
and copy the formula as far as you expect having data in "MasterList.xlsx"

When closing "MasterList.xlsx" excel will extend the formula with the complete path to "MasterList.xlsx"