linking to a sort on mastersheet?

Name the list of parents, workgroups, etc. using a dynamic range name. Then use a pivot table that refers to the dynamic range in your new worksheet. Drop the names of the parents and the list of workgroups into the "Drop Row Fields Here" section of the pivot table. Whenever you update the mastersheet, refresh the pivot table. Not the flashiest way, but it is the quickest way.

Thanks I'll give it a try