Automatically updating cells when opening workbook

I am working on a primary worksheet "Dashboard" where information in column B
associated to today's date in a secondary worksheets "Scheduled" is copied to
cells (Q27) in 'Dashboard' upon opening the workbook if the cell in column B
associated to today's date in worksheet "Draw" is empty.

Both 'Scheduled' & 'Draw' worksheets have dates starting with 05/01/09 down
in column A and the pertinent data in Column B.

Hope this makes since. Can anyone help write the code that would make this
happen? My ultimate goal is to not only copy data associated to today in Q27
but to also copy to Q28 with =Date +1, Q29 with =Date +2 and so forth through
= Date + 7. That should allow me to look out 7 days into the future on my
primary worksheet.