Take a look he

Changing Sheet Name to match cell, automatically
http://www.mcgimpsey.com/excel/event...efromcell.html


In article ,
jga wrote:

Dear Group,

I simply want to automatically name a tab with the contents of cell AI2. I
will have about 56 sheets in my book. Each sheet will be referenced by its
corresponding AI2 cell in each sheet. Can someone help me? Thanks