Given that you already have macros to create the projects from a template, I'd be inclined to have another macro/macros to consolidate the relevant data into an "all-embracing" worksheet. That would have a one or more rows for each project, each identified by the project number/name and any other "breakdown" details. Make the consolidated data into a Structured Table and you can sort it, filter it, create Pivot Tables and Charts.

That should make analysis and presentation much more straightforward.

When you create new project sheets from the template, you could put a flag on a control sheet to indicate that the workbook is "dirty" and the consolidated sheet is not up to date. And the consolidation macro would reset the flag. That could maybe run (automatically) when the workbook is saved or closed.


Regards, TMS