I have a workbook with lots of pages, every page is structured exactly the same, but the information within it varies.

I have a template sheet set up, so that if I want to change the labels on the sheet, I just change them on the template sheet, and they all change, easy.

The formulas within each sheet are also identical, so can I do this:

1, Place the formula on the template

2, Call the formula on each sheet from the template

Example:

Every sheet has a =SUM(A10:A220) formula in cell A1

Can I have this formula in Template!A1 as text and then somehow call that cell in A1 of every sheet, to work in every sheet?

I tried =INDIRECT(Template!A1) No Luck, but I am assuming there must be a way.

Why do I want this?

Well if I have a reference sheet where I can amend formulas once and it applies, instead of correcting formulas on every sheet, then it will save me lots & lots of time.

If the answer is in VBA I am also happy to consider, just have not found anything through searching.

Appreciate the help.