Hi Maxwell-5000,

If I may make a suggestion...

It might be a lot simpler to manage if you indexed the sheets and used
hyperlinks on "Master" that point to each sheet for that item. So, for each
item on "Master", there's a sheet with info for that item. When you add new
items to "Master", add a new sheet for each new item.

You could manage the item names on "Master" with the hyperlink text. For
example, to create a hyperlink for sheet "Apples", in the cell where the name
is now enter:

=HYPERLINK(Apples!A1,"Apples")

which displays the name "Apples" in the cell containing the formula.
Clicking on the cell takes you to cell A1 on the sheet named "Apples".

This way, you don't need to change the sheetnames because each sheet will
always be for the same (one) item on "Master".

HTH
Regards,
GS