Have Sheets feed child rows automatically into a Master Sheet?

MicW

Forgive me if this topic has been covered before, I've done the best I can searching.

So my employer wants to have our projects be listed in a sheet, each department in a different sheet and to have that information feed into a master sheet (or a couple master sheets actually). I know you can cell link one row at a time, but I'm wondering if there's a way to link the parent row so that all the child rows appear in the master sheet. For example if you add or remove a row from the parent that row will automatically appear or disappear from the Master sheet respectively and vise versa. From what I understand, using reports would be the best way to go to gather information from several sheets but my employer would find this more useful. So is this at all possible?

Brent Nathan

For my Master Sheet system, each project sheet has a  parent row across the top, which provides a summary of all it's children, start/end dates, overall progress % etc.

Then we cell link the summary row to a master sheet row.

If you are looking to dynamically update content to an overview,  you would be better off using reports or including multiple reports in a Sight overview.