Looks like you have lot going on w.r.t. status update. I would advise drafting final output for the dashboard that uses performance and/or risk indicators that are based on the dimensions that are of utmost importance to the stakeholders. Have you thought about stratification categories for these reports? Frequency on updating them is another criteria to focus how to update the weight for displaying it in dashboard.
You have to either share the workbook if you have it packaged so that I can suggest some options or think about intended audience and their interests to design layout.