I am trying to find a way to link my master sheet to new project sheets.
My Master sheet already exists and lists all our premises, product in them and also locations of product.
All we rollout new products - this all needs to be ammended in the master sheet.
Is there a simple way to link this master sheet to any new project sheets going forward - where if the project sheet is ammended - the Master sheet is automatically ammended also?
I know sheets can be linked by cell - however this would be extremly confusing to have to link via numerous cells.