Hi Dy,

Here is your workbook back with all the code you asked for. I also added a sub called UnHideAll. You should add the Dashboard sheet when you click on the individual weeks so you can then go to the other subs. BUT - you didn't ask for that.

VBA for Sheets Hide.xlsm