Final thing today...

I want to switch between worksheets in a macro, however, they will be
called slightly different things each time... each week it will be +1
last week... e.g. 'Week1Worksheet' will next week be
'Week2Worksheet' etc. (The number is the only thing that will be
different the text will be constant)- Is there a way to select the
sheet I want so I can switch between?
Help on this would be SO much appreciated.

Thanks

Solomon