Bill,
Thanks for the reply. It's not really what I'm after - I probably
didn't make it clear. Each row in the main sheet corresponds to a
different sheet in the workbook. So if Col A in the main sheet read:

ABC
ASR
CFT

Sheet 1 would contain ABC in A1, Sheet 2 ASR in A1 etc.

Bertie.


--
claytorm
------------------------------------------------------------------------
claytorm's Profile: http://www.excelforum.com/member.php...o&userid=11610
View this thread: http://www.excelforum.com/showthread...hreadid=382352