I have a template sheet which is used for many other sheets but my managers keeps moving the goalposts for part of the reporting meaning i have to update a formula on the template then copy and past into the other 18 sheets currently in use.

Today i set up a new sheet i thought i would try linking the formula cell to the template so if managers ask for a change again once i update the template then the new sheet would automatically update which worked :-) The problem then was i am unable to convert the formula to a column formula meaning my shortcut doesn't really work.

Is there a way to link the cell in each sheet to the template so when i update that formula all other sheets have same formula and make it a column formula?