See how to Merge Multiple Worksheets in Workbook To New Table using Append Feature:
(00:08) Problem Setup
(00:39) Table Feature for getting Tables into Power Query
(00:53) Use “From Table” feature in Power Query to get Tables into Power Query
(00:59) Keyboard Differences in Power Query between Excel 2010 and Excel 2013
(02:13) Discussion of Keyboard Shortcuts as a “Dance”
(02:33) Merge Multiple Sheets in Workbook To New Table using “Append Feature”
(03:51) Bug in Power Query November 2014 Update: Number Format not being picked up when Query is refreshed.