Add a new worksheet named “Mike”…
Worksheets.Add.Name = "Mike"
Add a new worksheet named “Mike” as the first worksheet, before all the other worksheet tabs…
Worksheets.Add(Before:=Worksheets(1).Name = "Mike"
Add a new worksheet named “Mike” as the last worksheet, after all the other worksheet tabs…
Worksheets.Add(Before:=Worksheets(Worksheets.Count).Name = "Mike"