Report using multiple sheets

Hi Andree,

Ideally, I'd like to just add 'heat map' coloring to the "pivot summary" sheet I have.  The "pivot summary sheet" pulls (cross sheet reference) in the %complete for each category: System, WoW, Training, Metrics, Users, Adoption.  The color coding would be based on the color of the Health dot from the 3 detailed sheets.  However, I am at the max for cross sheet references so I can't do that final important step. 

As a work around, I was hoping to create report that includes everything from the "pivot summary" sheet and in that format with the categories across the horizontal as columns, and then joins to the 3 detail sheets to add in the color status ball. 

When I create or play around with  the report I run into two problems: 

1)  the % do not show in the columns for the categories (System, Wow, etc).  It's blank.  The color status ball appears but so does each category going down the vertical (as rows) from that particular detail sheet . 

Or  2) I can get the % to show correctly and in the categories are in the correct horizontal column format, but the color status balls disappear. 

Any way to join these sheets?  Or maybe a better way to apply a heat map to the Pivot summary? 

Not sure if this helps or hinders, ha.....thanks for any insights.

Thanks

Ilene

Thank you...will do.  I have created test versions and will share.  Here they are summarized.  The ones highlighted in yellow are the detailed sheets and the one high lighed in green is the summary pivot view....where i have the format correct for what our leaders want to see but I am stuck at getting the heat map colors to shade based on the health of 'system', 'wow', 'training', 'metrics', users', ' adoption' from the details because i am at the max for cross sheet reference.