I have done it as you said and also changed it a little bit for dynamic file paths & name as follows:
In one of the cells, I put this code and changed the cell's name to "FolderPath":
Then I changed your power query code to this code:
Thank you for solution. Here I have two questions and I would be appreciated for your time and help.
1- How to change this power query code in a way that it just get cells with non-numeric contents.
2- How to change this power query code in a way that it just get contents of ranges in a sheet that we specify (for example Ranges like E8:Q30 in the TargetSheet or just three columns like Q:Q,I:I,B:B in the TargetSheet).
Bookmarks