Combine Multiple Worksheets Into One Worksheet in Excel Using Append Query

This video demonstrates how to combine date from multiple Excel worksheets into one master worksheet using the append query in Power Query.

This video will be useful to you if you are asking the following questions:

How do I combine multiple worksheets into one?
How do I consolidate data from multiple worksheets in a single worksheet?
What is append in power query?
How do I merge data in Power Query?
What is append in Excel?
How do I merge data from multiple tabs in Excel?
How do I merge two Excel sheets together?
------------------------

[beaverhudson]

this was so well explained and made a huge difference to my work! Thank you!

[maxkwok]

Thanks for sharing. I came across your channel due to the video about finding the first numeric char.
Your work is great and thanks for that.

[Siberian_valenok]

Thanks for the video, Chester. You got your tables all in one file (different sheets). Now what if your monthly reports are in separate Excel files, what would you do to append them into one file (or sheet)?

[cathywong]

How about if all the data in the worksheet is not a table, How combine the worksheet quickly into one?

[shoppersdream]

Thank you! Blank Query does not work if you have a lot of formulas in your tables/tabs

[zaydarendse]

Wow Thanks!! this is so going to lighten my work load :)

[TrishHand-cpvb]

I used your video and it worked fine. My client added information to the combined worksheet and now I need to reverse the process and get that data back into all the individual spreadsheets. When I do Refresh all the data still only goes one way and I lose all the information my client added to the combined spreadsheet. How do i get the same results but in the reverse process?

[davedonovan]

Thank You ! Can't remember how many sites I tried before using your guided approach - Just wish I'd found your site / hours ago - Life saver ! Dd

[imranali-iywk]

I have a folder containing 19 Excel worksheets with each worksheet containing 16 sheets inside it. While the name of the excel files are different, the name of individual sheets inside them is same i.e. they start from "Sheet 1" and go till "Sheet 16". What I have to do is append each sheet at the end of the next one and continue the same to get a new excel file containing only one sheet. (In other words, sheet 1 from file two (say, B) will be appended at the end of sheet 1 from file one (say, A) and sheet 1 from file three (say, C) will be appended at the end of the above two files containing sheet 1 from files A and B, respectively and so on untill every file is added).

[nicholaspachella]

I am able to get the query to work when adding new tables, but it wont work when expanding the range of the tables already within the query. I went back and rewatched the test transaction part about 10 times, but my query wont pick up the changes. Any ideas why that might be?

[susierobson]

Why don't I have the Get Data option? This doesn't translate into my version of Excel. Need help.