Delete the specified Worksheet (Sheet1)
Sub DeleteSheet()
Sheets("Sheet1").Delete
End Sub
Delete Worksheet based on user input
Sub DeleteSheetUserInput()
Dim x As String
x = InputBox("Enter the name of the sheet to be deleted")
Sheets(x).Delete
End Sub