Consolidate lists from different SharePoint sites into a single view where the data can be manipulated and exported to a spreadsheet. Create Standard views, Gantt views and Calendar views.