How to auto update forms in many spreadsheets

[nemo15]

Hi everyone - I am using many spreadsheets with the same template of formulas but different data. When I want to modify a formula or appearance, I have to make the change in all my spreadsheets individually...

What would be the best way to have a source template, to which the other ones would link and auto update formulas but not the data?

[Pepe Le Mokko]

Hi and welcome
depending on your layout you can eventually group the sheets.
All changes in one of the sheets then reflects on the others.
Don't forget to ungroup afterwards.

[nemo15]

Oh I forgot to mention, the sheets are in multiple files. I'm not sure but I don't think this will work in this case? I could only make them link within the same file.

Is there a way to base a sheet (template and formulas) upon another sheet in a different file?