sheet names

[Lorraine]

I would like to name a sheet reference back to a cell.
Example: If I type a client's name in cell B4, I want a
new sheet created with the name of that entry.

 

[Don Guillett]

right click sheet tab>view code>copy/paste this.

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.address <> "$B$4" Then Exit Sub
Sheets.Add.Name = Target
End Sub