Learn how to Combine Data From Multiple Sheets (Tabs) in Microsoft Excel using Power Query, auto expandable Table Objects and make an automatic master sheet with all the data combined into one tab.
Updated Versions:
Use Table Names with Dynamic Updates https://youtu.be/Je1sKHrVwuU
Include Worksheet Names https://youtu.be/bRnXAz4KaYM

Install add-in for Excel 2010/2013 users https://www.microsoft.com/en-us/download/details.aspx?id=39379