ExcelBanter - Collating data from one worksheet to another

I have written a macro that opens up a worksheet from a named individua
( the name of the worksheet is the individuals name ) that has been
mailed to me and it then proceeds to 'cut and paste' the data from th
source sheet to my master sheet. Once completed that particular macr
ends and the next one starts and that looks for the next persons shee
to copy.

The problem I have is that when anyone of the individuals do not sen
me their sheet, the macro assigned to them cannot find the sheet and
get a 'Run time error 9 Subscipt out of range ' message because clearl
it cant find the sheet it is looking for.

Is there any way of preventing this message popping up and instead th
macro merely ends and moves on to the next macro which will look fo
the next persons sheet ?

Any comments are very much appreciated, unfortunately the macros are o
a different pc and i cannot copy them onto here to show you but i thin
it is clear what i am trying to do.

Darre

--
DarrenWoo
-----------------------------------------------------------------------
DarrenWood's Profile: http://www.excelforum.com/member.php...fo&userid=1646
View this thread: http://www.excelforum.com/showthread.php?threadid=38332