Multiple Tab Project Tracking Dashboard

I have an extremely large project with about 50+ same/similar program workflows. Each workflow is about a dozen different steps (i.e. Research, Revise Documents, Create work-orders, etc.) with some steps having multiple iterations (i.e. Revise Document 1, Revise Document 2) within a program/work flow. Each Step is organized by Worksheet tabs (i.e. a master document revision tab, a master work-order tab) with a column indicating what work flow/program its associated with, along with columns for preparer, reviewer, due date, status, etc..

What is the simplest way to slice and dice the data into a dashboard? Regular Pivot Table doesn't pull from multiple tabs, I can't seem to wrestle power pivot with many to many relationships, we've tried POWER Bi, and MS Lists with no luck.

Ideally, I want a dashboard to filter by program/workflow, and see all steps, and iterations with owner, due date, etc. Looking for Suggestions.

Bonus points if it can take a another slice by owner (across workflow, programs, iteration, prepare/reviewer) to essentially be an individual's personal action/assignment list.