Merge data from all sheets in selected file
This article describes shows how to merge data from all sheets in some file into one table - without working with them individually. Power Query tool (Get and Transform) is used.
Doubleclick on the double-sided arrow in header of Data column.
Confirm and the merging query is done.
To have it nicer you can declare the first row as header and remove the headers from other sheets.