Total Sum from multiple Sheet Summaries
I have a project that includes three sites, and I initially decided to make three separate grids to keep everything independent. However, now I'm wondering if that was a mistake, as I would like to create a single dashboard that summarizes the entire project totals. I have created identical sheet summaries that show the total number of clients enrolled by each site, and would like to have a total for all three sites on one dashboard, but am not sure if that's possible, or where I would put that calculation.
It's fine if I need to include just the site totals on the dashboard and then enter the total manually, but it would be awesome if it could be auto-calculated.