I want to write a formula once in one sheet and have others call that formula and do calculation in their own sheet. I want to do this because calculations need to be done in 100 other sheets within the same document but I don't want to have to change the formula in every one of those sheets if we decide to modify it.
I am not sure I understand you requirement but perhaps a named range would help you. Take for example:
Now name A3 - the default would be
NamedRange1. This can be used elsewhere in the same sheet or in other sheets in the same document with:
6 wherever entered.
Now say change
^ in A3 above. Then all those
6 entries will change to
Excel doesn't have a built-in to return the formula, you will have to use this user defined function.