How can I use Power Query to pull data from a folder with dynamic subfolder names?

I have a process where new monthly data lands in a folder structure like MainFolder\2026-03\Data. I want Power Query to automatically pull from the current month's subfolder without me manually updating the path each time. I know I can use a named range with the folder path and reference it in M, but I'm wondering if there's a cleaner approach within Power Query itself.

What's the best way to make the folder source dynamic so it always grabs the latest month's data when I refresh?