The SharePoint List Collection web part can congregate lists from different SharePoint sites into one single view. In the view, you can work with the data and then export it to a spreadsheet.

The Lightning Conductor Web Part allows you to aggregate data from Lists and Libraries throughout the current Site Collection, and across Multiple Site Collections.  If you want to see all of your Tasks in one Web Part, instead of navigating...