With your team project tables synced in you can reference them all in one table to extra summary data such as percentage complete.
Below we pull in all of the Tasks and Task Stages with a SwitchIF() formula which matches the rows team with the correct table to pull data from. We then can do a simple calculation to see how many of the tasks are completed or not across all of a teams projects.