So here's my scenario. I have created several multisites (each has a separate db) each of which has a content type called "press release". I want the ability for my main (default) site to be able to aggregate and dynamically display every time one of these new nodes gets created using the same method that "Views" uses to display a "List View" for both a page and a block.

So does anyone have knowledge of a good option to do this? Is there a way to integrate content from multisites into views?

Some methods I've considered...
- Create an RSS feed for each site and merge them to display (not realtime)
- Write custom sql query (don't like this idea, the block needs to display on our home page)