Automatically name worksheets based on cell values from master sheet

[timlh42]

I would like to have names listed in sheet1 in column A, beginning at A3 and ending on A30.

So if there is a name in A3 ( George) and (Sam) in A4, (John) in A5 and so on, I would like it to change the sheet names from Sheet2 to George, sheet3 to Sam, sheet4 to John, etc

Is this possible?

 

[Fluff]

Oops, I forgot to put the . before cells, it should be

Sheets.Add(, Sheets(Sheets.Count)).Name = [COLOR=#ff0000].[/COLOR]Cells(i, 1)

 

[timlh42]

Oops, I forgot to put the . before cells, it should be

Sheets.Add(, Sheets(Sheets.Count)).Name = [COLOR=#ff0000].[/COLOR]Cells(i, 1)

Ahh... It works great!!!!!

Thank you for everything!!

 

[Fluff]

You're welcome & thanks for the feedback