I was able to implement this cross site collection list view webpart (link below). But know i'm currently modifying it so that i can pull from multiple lists. although, this is turning out to be more difficult than i thought. If you have any good resources that do not include a third party software, I'd appreciate it. thanks.
You could always try using Search to meet this requirement.This will depend on you being able to create a fixed query which returns only the results you require and the results will not be 'real-time' but instead dependent upon the frequency of your crawl. I wrote a post about this a while ago if it helps.
If you are looking for third party solutions which you can buy, check the link below: http://www.lightningtools.com/pages/lightning-conductor-web-part.aspx