You wouldn't actually link a workbook. Set a hyperlink to a sheet in the
workbook.... Probably the first one.

First you'd build the 50 od sheets for each week... Could be 12 for each
month maybe... I'd try both and see which one I / my users prefered.
Then start up another workbook and Insert / Hyperlink ... and point to the
first sheet in the workbook.

So for example... I'd have my new workbook open and then open week ones
workbook. Then Insert / Hyperlink into my new sheet and point to say A1 of
Sunday.

OTOH... You could have a list of the workbooks in a range, select one and
click a button to open it.