Hi Sixthsense,
The code works great! Thank you. However, how can I tweak it so that all four tabs are renamed at exactly the moment the text is entered in the first tab in cell D9? So, this would be a change event related to that cell? The tabs would not have the same name as the text entered in cell D9 since the value entered in cell D9 would be appended as the prefix with a space between to the existing tab names like this:

D9 = OAC

Tab 1 = 123 becomes OAC 123
Tab 2 = 789 becomes OAC 789
Tab 3 = 456 becomes OAC 456

Thanks