You need to explain the context, before we can help. For one, I have no idea what's good/bad and what's threshold value for KPIS etc... as well I don't understand many of acronyms used in your workbook.
But as general pointer, I'd definitely reorganize your data into flat table structure, so that it's much easier to link data and do analysis/dashboard on it.