How to insert tab name in the sheet by formula?

Use the above formula using either a button or sheet activate or you can use a module.

Formula:- Sheets("Sheet1").Name = "SheetName"

Sheet1 = is the worksheet you want to change the name for.

SheetName = is the name you want to change with.

Use the above formula using either a button or sheet activate or you can use a module.