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.

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.

Let me start by asking if you are familiar with Power Query (PQ) at all. 

It connects to all relevant tables in your file, does some cleaning-up and 'finds' the correct account codes. If you have never used PQ, it will be a challenge to do a quick step-by-step.

See attached. A very basic PQ solution.