whats the best way to copy query steps do dozens of sheets/queries?

[Guitarmageddon]

So here is the gist of how my source data workbook looks, its kinda messy:

I want to use power query to basically fill down the cells (originally I was going to try and use VBA but I saw power query has a function for this!), and then combine the data from all the sheets. I get as far as having the steps on ONE of the sheets, but get clueless when it comes time to copy the steps to ALL of my queries. Am I doing this the best way possible?

What Im seeing is.... I can get my applied steps done as I modify them in the first sheet (01100 in this case), but am I supposed to go to advanced editor and copy paste the steps to my dozens of queries over there on the left?? Is there a better way to clean this data and get it combined into one master table? Is this a job for append query/merge query somehow? Sorry, Im still learning this all.

 

[StuLux]

Have you investigated merging the worksheets to one sheet using power query - if you can do this then use power query to fill down the cells you'll be left with one table with all your data. Try a google search for 'use excel power query to merge worksheets' for help.

 

[Guitarmageddon]

Ok Im going to check there first. Seems doing that step FIRST would solve some of my self-inflicted problems haha. Also, does it have to be a table? none of these are tables

 

[sandy666]

if all tables has the same structure use Append feature (not Merge, because Merge in Power Query means something completely different) then you can use FillDown

 

[Guitarmageddon]

Ok update, so this was extremely helpful

Combine All Sheets in a Workbook with Power Query

You will learn how to combine data in all the sheets in an Excel workbook using Power Query. You will learn the required tips and tricks.

exceleratorbi.com.au

I didnt realize I could simply right click on the master workbook, click edit, and then do my steps THERE versus having the query see all the tabs individually like I was doing at first. This gets me 50% of the way toward my goal. Now Im just digesting how to flip all this data around and construct relationships for what I think my peers will be asking me for.... I will solicit you gurus very shortly Im sure!