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?
------------------------