Is there a way I can change the text in cell A1 and it change the Tap to the same name

[rcirone]

Is there a way I can change the text in cell A1 and it change the Tap to the same name

 

[Joe4]

I assume you mean "tab" and not "tap".

Right-click on the sheet tab name at the bottom of the screen, select "View Code", and paste this VBA code into the VB Editor box that shows up:

Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.Address = Range("A1").Address Then
        ActiveSheet.Name = Range("A1").Value
    End If
End Sub

Now, whenever you manually change the value in cell A1, it will update the sheet name, as long as it is a valid name not being used by another sheet in your workbook.