Link or paste cells based on Date in cell

Please advise whether the following is also possible.
I have the following formula in cell B52:
=IF(WEEKDAY(TODAY(),2)=5,TODAY()+1,IF(WEEKDAY(TODA Y(),2)
=1,TODAY()-2,""))
Is there a single formula that will paste/link the value
(TIME)of cell D2 into cell D53 if the value (DATE) in B52
is Dec 6; and paste/link the value(TIME)of cell D12 into
cell D53 if the value (DATE) in B52 is Dec 13; and
paste/link the value (TIME) of cell D22 into cell D53 if
the value (DATE) in B52 is Dec 20; and paste/link the
value (TIME) of cell D32 into cell D53 if the value (DATE)
in B52 is Dec 27; and leave cell D53 blank if cell B52 is
displaying a blank due to non-friday/non-monday print date?
Cell D53 and others are the 'running' daily record of
hours worked...they are linked to a worksheet (Weekly
Timesheet) which is ultimately printed on a Friday or
Monday...if no single formula works, is there a macro or
something that can be used???
Thanks again!