How to name a worksheet based on text entered in a cell

Hi.

Could Excel give a tab a name, based on values/text entered in a specific cell?
Example:
Sheet1 Cell A1 contains value "ABC".
Are we able to name the Sheet 2 "ABC" by some written formulas?

Thanks.
Friend.

Hi,
Formula is unable to do such process, but VBA could do it.
Such as these code:

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$A$1" Then Sheet1.Name = Target.Value
End Sub