Power Query Question

[Guzzlr]

Hello.
I have been successful at bringing in two different excel files into one Workbook (two sheets in the same workbook) with the Power Query option in excel. However, I can not figure out how to get two seperate excel files from two seperate workbooks, where both sheets are combined into one sheet in the same workbook. I would like to try and stay away from copy paste a sheet into an exiting sheet. I would rather use power query so I can choose what data I want in a combined sheet.

What am I doing wrong?
Thank you

 

[RoryA]

You need to create an append query that appends one query to the end of the other, then load that to a table, not the two individual queries.