You could use a hyperlink formula. Assume the formula which gives you
the week number is in cell A1, then in an adjacent cell you could add
this formula:

=HYPERLINK("#'Week "&A1&"'!A1","jump")

This will display the word "jump" and if clicked it will take you to
cell A1 in the appropriate "Week no" sheet. As you have spaces in the
sheet names you will need to have the apostrophes in the above formula
- there is one after the # and another one before the !.

You might like to have another one in every sheet which always takes
you back to the main sheet - once this is set up you can just copy it
to the other sheets.

Hope this helps.

Pete