Dashboard or Project Level View of Multiple Boards using Filter

Hi
We are a property management company and have several boards that represent different functions of our business (i.e. rent collection, evictions, move-in, move-outs, etc), but I am struggling to have a holistic view of all of the items in a 1 dashboard view. The dashboards are great but we can’t filter on a specific building without filtering by each board (which is really cumbersome).
Has anyone found a work-around or add-on app that helps provide this full visibility- Specifically an ideal use case would be a dashboard where I can do 1 dashboard wide filter on “Property A” and then it will show me all the items/sub-items that match that criteria across multiple boards.
Thank you!

Hey there! Do you think a Dropdown Column in your boards with the different building types as dropdown options could be helpful here? Then, you can filter by the Dropdown Column options in your Dashboard.

Let me know what you think!