How to Excel Magic Trick 1330: Append All Excel Tables in Current Workbook: Power Query (Get & Transform) #
About The Author
Excel is my Passion and VBA Love of Life. I like to solve and automate any possible opportunity in Excel including in combination with Office Applications (Access, Outlook, Word, PowerPoint, Visio, etc) and other Non-Office Applications (SAP, IE, Batch, Configuration Management Tools, etc).
Note: All the solutions given here are published after thoroughly tested to my knowledge, however it is advised to keep a copy before you try it.