Combine and Consolidate Multiple Excel Files into One

Consolidate multiple worksheets into a pivot table:
This video explains the easiest way to combine multiple Excel files from a folder into a single workbook and create a pivot table based on the consolidated data.