Append files from a folder into a table

[Sanjica]

Must all of the worksheet names in a file be the same? I did a test and noticed that when worksheet names are different I get an error. 

[Greg_Deckler · Accepted solution]

Probably depends on your Navigation step. Take a look at this:

https://www.excelguru.ca/blog/2014/11/19/combine-multiple-worksheets-using-power-query/

You should be able to use this technique to access the same sheet number (1st, 2nd, 3rd)