Hiya,

Use Error handling to skip over where your sheets don't exist.
On Error Resume Next switches the error handling off
On Error Goto 0 switches it back on

----------------------------------------------------
Sub HandleSheets()

On Error Resume Next
Sheets("NotThere").Select
On Error GoTo 0

End Sub
------------------------------------------------------
http://www.excel-ant.co.uk