Using a master sheet to change multiple sheets

Currently, I have a project template that I use for opening a new location. Our company is typically working on 5 or more location opening projects at a time. When changes need to be made to the basic structure of the project plan (i.e. deleting a task, adding a task, adding a column etc.) this change has to be made across all of the active project which can be very tedious work when we have multiple going at the same time.

Is there a way to edit just one sheet and have that edit populate to all of the other sheets?

Best Answer