In SharePoint out of the box, you cannot easily see all List information across multiple SharePoint sites rolled up into one relevant view. The List Rollup Web Part rolls up selected lists into a single Data View Web Part.
How to use the List Rollup Web Part
| For SharePoint 2007 | For SharePoint 2010 | For SharePoint 2013 |