Very pleased to announce a new web part today, the Lightning Conductor Web Part. Brett is to blame for the name, but it's quite catchy once you get used to it! :-)
We're always getting asked on consultancy and training gigs about the limitations of the Content by Query Web Part and its limitations in that it can only roll up content within the same site collection. Well we've decided to do something about it! The LCWP can aggregate your content from sites within the same site collection, but also sites across site collections!
Obviously another limitation of the Content by Query Web Part is that it is only available for MOSS 2007, but with the Lightning Conductor Web Part you can get list and library aggregation for WSS 3.0 as well.
For more details, a screencast, and a trial download check out this link:
http://www.lightningtools.com/pages/lightning-conductor-web-part.aspx