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?
