The SharePoint List Collection web part can combine 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.