J.W. Aldridge wrote:
stevebriz wrote:
Worksheets.Add(befo=Worksheets(Worksheets.Count )).Name = "MySheet"

I believe this will work however, is there a simpler way to insert this
one into my code?

I am getting thrown off with fitting it into my code and referring to
my sheet names.
The names of my sheets are "start" & "end".
Any sheet added will need to go in between these two.

Not sure I understood you correctly but here goes....
If the "start sheet is before the "end "sheet then the below will work-
then you can use:

Worksheets.Add(befo=Sheets("end")).Name = "MySheet1"

but you need to be careful not to try and add a sheet with the same
name or you will get an error.