About Combining Tables in Mutiple Sheets

Hi udonlover here are the steps below:
1. Convert the worksheets to a table using Ctrl + T

2. Go to Data Tab

3. Click on Get Data >> From other Sources >> Blank Query

4. In PowerQuery Editor, click on Advanced Editor

5. In the Advanced Editor in front of the "=" sign type "Excel.CurrentWorkbook()" and click okay

6. In the column titled name, select the filter and choose the files you want to combine together and then right click on the column and remove it.

7. Go to the content tab and click on the icon at the top right and uncheck the box "Use original column as prefix"

8. Go to the Home tab and at the top left of the click on "Close and load" and select table.

I've attached few pictures if that would help.

Regards.