Automatically naming a tab

[jga]

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

 

[JE McGimpsey]

Take a look here:

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