1 July 2018
This tutorial shows you the exact steps required to combine multiple sheets into one single table using Power Query.
When using Power Query to combine data from all the Tables in a workbook, you will likely face an issue where Excel double counts your data. The tutorial also shows you how to avoid this issue.
A sample workbook is available to download, so you can follow each of the steps yourself.
Full article: Combine data from multiple worksheets into a single worksheet
