Hi Chris,

Am Thu, 8 Mar 2012 09:36:48 +0000 schrieb Chris Mizon:

Cell B5 ='Staff Member 1'!B$7
Cell B6 ='Staff Member 2'!B$7
Cell B7 ='Staff Member 3'!B$7
....
...
Cell B66 ='Staff Member 62'!B$7

in B5 try:
=INDIRECT("'Staff Member "&ROW(B1)&"'!B$7")


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2