Project sheets roll up into a Program sheet, with bi-directional syncing of worksheets.


I am looking to have sheets have a bi-directional sync between worksheets. Wanted it to be more of a Parent/Child relationship, where the Parent sheet can have 1 or more Child sheets roll up into it. While allowing the editing and syncing of each child sheet by both sheet editors. Scheduled or near real-time bi-directional sync.

The Master sheet owner can edit both Master and Child sheets. The child sheet can only edit the Child sheet.

Looking for options.