Automatically change all external links based on a cell value when an Excel file is open

Dear all,

I have an Excel file which has a few external links such as: ='C:\Data\R_2017_01_01.xlsx'!Tickers

Here R_2017_01_01 is the Excel file name (2017_01_01 is a date).

Assume now the date is 2017_01_02. There will be a file R_2017_01_02. Now I want to automatically change the link from R_2017_01_01 to R_2017_01_02 when the Excel file is opened. Next time, for any date, I want this link change to happen automatically when the file is opened.

Note: Cell A1 gives the date for the old link (e.g. 2017_01_01), and cell B1 gives the date for the new link (2017_01_02).