Use uma declaração if:
Sub Worksheet_Loop()
Dim ws As Worksheet
For Each ws In ThisWorkbook.Worksheets
If ws.name <> "Sheet1" and ws.name <> "Sheet2" And ws.name <> "Sheet3" then
Debug.Print ws.Name
End If
Next ws
End Sub