Merge multiple excel files into different tabs of one workbook using Power Query on Mac

Hello,

I have 33 excel files in one folder. all of them have data in "Sheet1". the data are in the same position in each file.

I am trying combine those data from different files into one workbook, but in different tabs .

Is power query the correct and easiest approach?

If not, what is the most painless way to do this?

Sample files in a "Data folder":

Expected results is in file "expected_results.xlsx".

Thanks a lot in advance!! 

Rachel