Combine Data from Multiple Workbooks in a Folder Using Microsoft Excel’s Power Query

Microsoft Excel Tips and Tricks

In this Microsoft Excel video tutorial I demonstrate how to combine multiple workbooks (stored in the same folder) in a single workbook. The method shown in this video uses Power Query.

Credit Chester Tugwell