Power Query

[asifprpt900]

Dear All,

Can Someone please help me with Power Query?

I have multiple excel files in different folders as below:

Projects
-2023
--Log Sheets
---File-A-2023
---File-B-2023
---File-C-2023
-2024
--Log Sheets
---File-A-2024
---File-B-2024
---File-C-2024
-2025
--Log Sheets
---File-A-2025
---File-B-2025
---File-C-2025

I would like to combine all these files in to one master sheet. there are other excel files in these folders but i need to combine only the mentioned files (blue font color).

I already have a combined file for year 2023 & 2024 prepared by an ex-employee who already left the company. is it possible to add the files of 2025 into the existing master file?

I will be very grateful if someone could help me with this.

I tried to attach the existing file, but failed due to the size (15087kb)

Thank you

[AliGW]

Create a sample workbook with reduced data.

There are instructions at the top of the page explaining how to attach your sample workbook (yellow banner: HOW TO ATTACH YOUR SAMPLE WORKBOOK). Screenshots are of little practical use as we cannot manipulate them.

A good sample workbook has just 10-20 rows of representative data that has been desensitised. The sample layout accurately matches that of your real data. It also has expected results mocked up, worked examples where required, relevant cells highlighted and a few explanatory notes.

Failing this, post the PowerQuery M Code from the workbook and encase it in code tags.