Try this in C2 copied down and across:

=IF(INDIRECT("Day"&COLUMN(A1)&"!C"&ROW(A2))=0,"",INDIRECT("Day"&COLUMN(A1)&"!C"&ROW(A2)))