Coding for a Summary page? Out of my depth

Good day Excel mates,

I had a job flow down to me for data analysis to catch degrading products. I have about 9 pages of data to be collected, but I'd like to setup a "Summary" style page to consolidate the information and tell me what's degraded. I'm not the most creative so coming up with a solution has been challenging as well as learning how to summarize all this data. My idea was to try and create a Red, Yellow, Green type page to display what specific sections of data are showing degraded or may be completely depleted.

Someone mentioned to me that they worked with a company that had a product (doubt it was Excel based) that was able to click a button for an overarching department, then it would display what area is degrading, click that and would be more specific as to where the degradation was focused. Is this a thing that is possible? I don't know coding, mostly just basic to intermediate excel functions and formulae. Any direction or ideas would be greatly appreciated or if anymore information is required. Thanks in advance!