Im afraid i dont have a best effort to show here as i am very very new to trying powerquery.
I can do this in VBA, but i would like to give powerquery a shot…

I have N number of sheets in a workbook
i want to iterate over the sheets and only pull data from sheets whose name start with “d_”.
Further more each sheet has a local table and named ranges from which i would like to extract data into my new table.

i googled on how to iterate sheets in power query and extract data, but not much.
best i can find was this: https://community.fabric.microsoft.com/t5/Desktop/Looping-though-tabs-or-tables-to-extract-data-from-excel-files/m-p/932205

Any help would be appreciated.