Combining multiple Excel files located in a SharePoint site to a single Excel file automatically

On this video I show you how to connect Excel to SharePoint and combine multiple Excel files located in the SP site to a single Excel file automatically. If any changes are made on the SharePoint file, like adding or deleting an Excel file, this would be automatically reflected on the Excel that combines all.