Multiple Private Project Trackers Connected to one Master Sheet


I am working through building a solution. Here is what I am looking for:

  • Each team under a director has their own private project tracker sheet
  • Only those teammates can see the tracker plus the director.
  • The director has one master sheet that only she can access that lists everyone's projects together.

Is this possible?