in A1:

=IF(INDIRECT("Week"&(ROW()+11)&"!L$3")=0,"",INDIRE CT("Week"&(ROW()+11)
&"!L$3"))

adjust 11 to suit

On 18 Mar, 14:10, "Yrrep" wrote:
*I want to copy the formula below down the sheet so that the week
increases. i.e. week 12 week 13 etc. (The week represents a different named
sheet)

=IF(Week12!L$3=0,"",Week12!L$3)