VBA rename sheet based on calculated cell value

[Tuan Kriel]

I already have VBA code using a "Worksheet_Change" event that works successfully to rename specific sheets in an Excel workbook once a value from a dependant dropdown list on the cover page "Sheet1" is selected. On the same sheet1 in a separate range "Y120:Y127" a formula concatenates the dependant drop down value ex. "Pumps" with "Purch" so that:
Sheet2 = "Pumps" (drop down list dependent)
Sheet3 = "Pumps Purch" (formula concatenated dependant)

I need some way or a trigger or change event that I can apply so that every second sheet would also be renamed based on the cells on sheet1 range: "Y120:Y127" when the cell value are changed from blank ("") to the text string in the example above.

Any help would be appreciated.

Thanks.