This would be possible with a multisite install, you can then do switch_to_blog() and then query the posts on individual sites. http://codex.wordpress.org/Function_Reference/switch_to_blog
Outside of a multisite install I don’t think this would be possible.
