Excel - Task Tracker, Upcoming Deliverables, and Status

[thedarce21]

Hello,
I am trying to use a workbook to manage a large project with several different workstreams.

Workbook configuration

• Workstreams have their own separate tab that contains lines per subtask
• Master List tab that pulls all cells from the workstream tabs (and will update when changes are made on those tabs)
• Tracker tab that pulls from List tab (contains tables by user, work step, outstanding vs complete by month)

Key stakeholder now wants to know the COUNT of the below in a graph chart or dashboard tab for each workstream:

• By work step (prepare and review)
• Status (complete, delayed
• Items due next week

 

[thedarce21]

Sorry - I can't figure out this add in