Macro for saving / loading values between sheets

Hello all,

I've been trying to write a macro for taking values that are entered on one worksheet and saving them on anothe worksheet; where they are saved is based on a value that is entered on the first sheet.

In the example provided, and on the "Today's Values" worksheet, I have fields for values 1 - 15. Only green fields require an entry by the user. In the "Today Is" field, there is a data validated list. This list validates to the values of the top row on the "Weekly Log" worksheet. So depending on the "Today Is" field, I need the macro to take the values and put them in the corresponding value fields on the "Weekly Log" worksheet. This would be the effect of the "Save" macro button.

Also, I'd like to make it so that I can recall values that are already entered. This would be based on the "Today Is" field, where upon hitting the "Load" macro button, the values for that given day that are currently in the "Weekly Log" sheet will repopulate on the "Today's Values" sheet.

Can anyone provide some insight and help? Thanks!