I'm trying to run a macro and I'm getting an error on the top line of this snippet:

Sheets.Add.Name = "DigikeyRateVariances"
Set DKData = ActiveSheet
myRow = 4
myCol = 4
Do Until CADsheet.Cells(2, myCol) = ""
DKData.Cells(myRow, 1) = CADsheet.Cells(2, myCol)
myCol = myCol + 1
myRow = myRow + 1

The error reads 'That name is already taken. Try a different one' I've tried changing the name of the sheet above in quotation marks but I still get the error, nowhere else in my macro is this sheet referenced which is why I'm confused as to why it would try to create 2 sheets, can anyone help please?