Anyone have a clue how to automatically rename sheet tabs to a name in a cell in another tab?



So, if sheet 1 in A2 has the Value "OAC-125" then the following tab names would be updated with that name as follows:

Sheet 2 - Current Name: DAR Updated to: OAC-125 DAR
Sheet 3 - Current Name: ZKL Updated to: OAC-125 ZKL

you get it ha? I thought maybe some formula can be entered with the concatenate symbol in each tab like this:

Sheet 2 - Sheet 1! A2 & DAR

Any idea guys/gals? thank.s