Import Formula from another file

[tomb1234]

Following the successful resolution of my last question, I have one more which I am having trouble with. I suspect it is a case of trying to find the correct function name but alas it is proving difficult.

OK...

I am looking for a formula that imports another formula from a different spreadsheet which replaces the original formula in that cell and then gives the output that that formula would calculate;

So people understand why, I have over 200 spreadsheets of information that I want to apply the same formula to in several of the columns, but because the information that the formulas interpret is a little subjective, the formulas may have to change at a later time. I want to avoid having to go back into 200 excel sheets and change the formulas by having a "master formula" in a separate excel sheet which the 200 use, therefore one change to the master changes all the rest.

Thanks,

Tom

(p.s. please let me know if more clarification is needed).

[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)

[tomb1234]

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...?