How do I create a Master Sheet with formulas that, whenever those formulas are updated, it updates those formulas in sheets made by copying it? So whenever changes are made to the Master Sheet, linked sheets are updated with the same changes in terms of formulas. And if possible structure as well, so if a column is added, that also gets added to all linked sheets.
Very much like how a slide master works. You know, how if you update a header/footer or add a text box/image in a slide master it updates that in every slave slide of that template.
A scenario: A school enters data through a google form. This is then brought into separate sheets for every class. Say I have 15 classes total. These are then updated by the class teachers with things like say attendance. Now if I change one small thing in one of those class sheets, I have to edit all 15 sheets.
Link to sample google sheet: https://docs.google.com/spreadsheets/d/18aPWgfoAcc4NUyvK3hJcFfP6rW2zgFF9NrtgT8NRFjs/edit?usp=sharing
Sometimes Macros work but not always and a new one must be made each time, and then run for each sheet. This is not efficient if you have 63 sheets to update like me.
It feels like one of those things that should already be there! Must be good reasons not to be.
Is there a way to do this either through formulas or through code? I haven't done scripts so would appreciate any help. If possible a method that is data agnostic.
PS: If this can't be done, is there a way to define a macro that works for multiple sheets?
