First, I changed your Master Data into a Table (Insert Tab> Insert Table)
Checking on the "Table Design" tab, I see this table is labeled "Table1"
This allows you to add new kids to your master tab and the table will automatically expand to include them. You can then refer to Table1 in your formulas instead of typing out a specific range.
Then I selected all of your other tabs (click on "KB", then holding the SHIFT key down, click on the last tab "6thGr"
This groups the tabs so that what you type in one of these tabs will be typed into all of these tabs. (makes things a lot easier).
Then in D2 of KB
In C2, a similar formula
Copy the two columns down as far as you like (I did down to row 30)
Again, because the tabs are grouped, these formulas will automatically be transferred to the other sheets.
Right click on a tab and "Ungroup"
Done
Bookmarks