Import Formula from another file

Originally Posted by robertswart

Put in one mastercell, let's say cell A1 on tab mastersheet '=function <- do not forget the ', let's say you want to sum A10 til A79, then it will be '=SUM(A10:A79)

Then put on all other sheets =indirect(mastersheet!A1)

Unfortunately this isn't working for me, not sure why. In the
"other sheets" I keep getting either #REF or #VALUE,

Any idea where I may be going wrong to get these outputs...?