Multiple Projects into one Summary
I am trying to set up a workspace to help manage multiple clients via projects. I have set up a template set for each project that includes plan, dashboard, key reports. My next step is trying to to roll up each project sheet into one summary for management. I was able to add a checkbox to each template so I can get a consolidated report from multiple sheets, however I am having trouble grouping them (ie, I want to know total 'Not Started' for each individual project). Is there an easy way to do this? I am trying not to link cells, since each client will have a new project template set.
Any help is greatly appreciated!