Open both files at once and create  your formulas using clicks into the data
in the second file.

Then, later, when you open  the first file, it should ask your permission to
update the values  from the other book.