@ Rob,

Please use code tags while posting code. I have added the code tag for you this time.

try

Code:
Worksheets.Add before:=Worksheets("SpecificSheetName")