|Sheets can be referred to by their position in the workbook (Sheets(1), Sheets(2), Sheets(Sheets.Count) for the last sheet, etc.) or by their name - Sheets("My Sheet")|
They can also be referred to by a variable that represents a Name or number.
Here are some examples....
'Add a sheet as the last sheet
'Add a sheet as the second sheet
'Name / Rename Sheet2
Sheets(2).Name = "My Second Sheet"
'Delete the first sheet
'Delete a sheet by name
Sheets("My Second Sheet").Delete
'Delete Sheet 3 by variable
varSht = 3
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.