This would have to be managed externally. Whilst you could set up paired organisations so certain users could log in to multiple orgs and view data that would not be presented in a single view.
This sounds like you'd need a reporting tool with API access to all orgs to then consolidate the data.
------------------------------
Richard Chandler
Conn3ct
------------------------------