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 [ Ссылка ]
Include Worksheet Names [ Ссылка ]

Install add-in for Excel 2010/2013 users [ Ссылка ]

свернуть