Dave - One of the things I have seen is a limit on the amount of storage allocated to a site collection. You'll need to check your configuration to make sure you have enough space allocated for each site collection. As Dink said, there is no OOTB solution or web part for cross site collection aggregation...