Filling a Social Media calendar by query

Hmm. So I played around with Connected Tables and Mirror Columns and I’m not 100% sure they’re going to work, but let me try showing you what I’m working with. This is the board I’ve built:

Now, three of those (Whitepapers, Company Blog Posts, Exec Blog Posts) are all handled by different teams with their own boards. I’ve trimmed down the fields (and haven’t really created everything I wanted yet) because I want to make sure what I want to do can be done =).

What I’d like to do is take the (uncreatively named) Content Calendar that the Company Blog Post team uses and feed it into my board, specifically into the Company Blog Post group. The Whitepaper Launch board would populate the Whitepapers group.

Each of the other boards I want to pull from have their own publish date field that I’d feed into a date field, same with URL, title… not sure I need more than those tbh. Holidays/Internet Observances would be campaigns I add myself.

Based on what I’ve tried with Connected Tables, it doesn’t look like it has the ability to funnel like that. It’d be more useful if I was a PM of PMs and wanted a dashboard look at all of their projects to see where we were as an org?