If you Google: excel vba worksheet rename event ... you get a few suggestions, mostly from other forums though so I hesitate to provide links.

It's a bit of a botch up but it looks like it could be done.

Regards, TMS