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.

To create a SharePoint list collection web part, firstly, you should select a site, a list in the site and a list view of the list.

Then choose list columns to collect data, select or input new column names for original ones so these columns will be aggregated and displayed in the SharePoint list collection web part. Repeating above actions, you can get SharePoint combined lists.

Eventually. all the SharePoint combined list items will be displayed in the list collection web part.

You can create Standard view, Gantt view and Calendar view for SharePoint list collection Web part to filter, sort or group data. These SharePoint list collection views are also created to re-organize data of the list collection. You can create public or personal list collection view to determine which list or list view will be filtered, which list columns will be displayed, and which column will be sorted and grouped.