Hi Laly,

Am Fri, 19 Apr 2013 03:51:44 +0100 schrieb Laly1:

i.e. in cell A1, formula reads =Sheet1!$C$3,
then in cell A2, =Sheet2!$C$3,
cell A3 =Sheet3!$C$3 etc.

in A1 try:
=INDIRECT("'Sheet"&ROW(A1)&"'!$C$3")
and copy down


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