How To Resolve Already Existing Name Range Error When Copying Excel Sheets

When you create an excel template with formulas,you might need to use that template to create more worksheets going forward to make work easier. This sometimes cause a name range conflict on the excel sheets which at
some point you will not be able to copy/move an a sheet due to the infinite warning dialogs showing name range conflicts.

See below example error

How do you get rid of this warning messages?

There are two method:
1.Use Name Manager by pressing CTRL + F3,then review all the names in the workbook and delete
the conflicting names.
2.Use code delete the names.
-Right click on excel sheet.
-Select "View code".
-Paste the code bow then click on "Run"

Sub TOOLS_DELETENAMEDRANGE()

  Dim nm As Name
  On Error Resume Next

  For Each nm In ActiveWorkbook.Names
    If (MsgBox("Delete name- " & nm.Name, vbYesNo) = vbYes) Then
      nm.Delete
    End If
  Next

  On Error GoTo 0

End Sub