Hi,
Here's a simple code to add and name a worksheet also delete the named worksheet.
Place this code in a module. Test on sample sheet ony.
Code:
Sub AddWorksheet()
Application.DisplayAlerts = False'' this will prevent warning about deleting the sheet
Sheets("Your sheet name").Delete
Application.DisplayAlerts = True ''this will reset the warning
Worksheets.Add().Name = "MySheet"''' change "MySheet to the name you want
End Sub