Power Query

[mrauch]

Hello

I have 5 files. Each with 5 worksheets.

For each file am trying to consolidate 5 work sheets into one file using Power Query - so I land up with 5 files that each have one worksheet.

Worksheet names are AUG_DATA, SEP_DATA, OCT_DATA, NOV_DATA, DEC_DATA. I am trying to consolidate 5 months of data into one worksheet.

All column headings in the worksheets are identical. (I have triple checked). I have a column called Month which corresponds to the worksheet names referenced above.
I am following these exact instructions. https://trumpexcel.com/combine-multiple-worksheets/
They sort of work and get me where I want to be but when I follow the steps the results returned will only give me an out put for one month of data or some files will give me 2 months.
When the data appears in Power Query Editor (before I click "Close and Load" and I select the drop down for the "Months" column to see what all months were pulled - only AUG data appears. There is an error message at the bottom of the drop down box which says "List may be incomplete" and I can click "Load More".
When I click Load more - all worksheets appear AUG_Data thru DEC_Data. I click enter but when I check the column labelled "Month" it still only shows AUG data.

Can you help me trouble shoot some possible reasons why this does not work??

 

[sandy666]

I have 5 files. Each with 5 worksheets.

If all tables in all files has the same structure use From Folder option then Append.
that's all what I can say without representative examples.