Wow! You made it so easy!!!

Thank you

"PCLIVE" wrote:

I would use VBA for this.

Sub NameSheets()

For sh = 1 To 18
Sheets(sh + 2).Name = Range("A" & sh).Value
Next sh

End Sub

HTH,
Paul

"Cheri" wrote in message
...
I am wanting to automatically name all sheet tabs from a list I have
created
on a worksheet named Team. I have set up 18 sheets currently named Sheet1
through Sheet18 (besides the first two named Team and Stats).

I would like to have each tab renamed respectively according to the list I
have on the Team tab in cells A1 through A18.

I have tried a couple other tips on here but they merely add more sheets
and
I have data on the current sheets that I want to rename.

Thanks,
Cheri