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...