Automatically select a selection from a drop down list based on current date

Hi,

I have created a dashboard with donut charts which keep track of a number of tasks completed and the number of tasks still left to complete.

Every week I have to give an update of the progress of work showing the percentage difference and current completed for each task from week to week.

I have created a drop down list giving me a percentage difference for each/new weeks coming using the =Today().

Every week I would like the percentage difference cells B5,C5 and D5 to change automatically, from a specific date in the drop down list (L11) without having to manually select a date from the drop down list. The sheet does it automatically when I open the sheet.

Is this possible?