Auto-update when the week changes

Hello all. I am new to this forum, I have some experience with excel, but none with VBA. I have seen that people here have a good knowledge on excel and vba programming, so I decided to ask for your help.

I have a worksheet that needs to change the link it has to another workbook every week. I have the calendar split week by week on both workbooks. The file names are always the same, changing only the number of the week. How can I automate this process with VBA? For example, now the first worksheet has a reference to W10, on monday, this workbook will have to point to W11 and be saved to yyyy-W11.

My calendar table looks something like this:

200509 28/02 01/03 02/03 03/03 04/03 05/03 06/03
200510 07/03 08/03 09/03 10/03 11/03 12/03 13/03
200511 14/03 15/03 16/03 17/03 18/03 19/03 20/03

As you see, the end of each file is on the first column

My intention is to compare the table containing the calendar with the system time, and then use this to create the new filenames. So, when the system time reaches 14/03, the file name changes to yyyy-200511 and so on. Can it be done and how?

Thanks in advance.

no one have any idea?