if you place this in column A and copy across to column B, etc you will
get the value from cell L52 on sheet week1, then week2, etc. Does not
appear to require the sum function.

=INDIRECT("week"&COLUMN()&"!L52",TRUE)


--
duane


------------------------------------------------------------------------
duane's Profile: http://www.excelforum.com/member.php...o&userid=11624
View this thread: http://www.excelforum.com/showthread...hreadid=546580