About Combining Tables in Mutiple Sheets

Hi udonlover, here are the steps below:

1. Ensure all sheets have identical headers and convert each range to a table using Ctrl + T
2. Open Power Query - Go to Data > Get Data > From Other Sources > Blank Query.
3. Click Advanced Editor and type in Excel.CurrentWorkbook() in front of the equal sign
4. Remove the column titled "Name" and expand the column titled "Content"
5. Go to the Home tab and click Close & Load, to export the file and then select Table.

Hope you find useful.