Getting Error 1004, can't get it to stop

I've tried un-commenting

        'Set wsNew = Sheets(Target.Offset(0, 1).Text & "_" & Target.Offset(0, 2).Text)

but i'm still just getting out of range even when i change sheets to worksheets.