Holiday planner

Looking at a very complicated holiday book folder.

to input holidays you have to open a different spreadsheet for each week,
this has 7 sheets, one for each day, a lookup table holding headcounts for each shift. and a menu/overview sheet that gives the amount of hours avaliable for each shift, and whether that is within limits or excedded, based on a percentage.

my question, is there a way of setting up a control menu that has all the weeks on it and when you select eg week 20, it then opens week 20 spreadsheet. this would be a short fix, until I have foundout how to redisign the whole thing.

each week is a different wookbook 52 sitting in a folder on harddrive,
each wookbook has 9 sheets, 1 for each day to input names and hours for each group, 1 is a data sheet which is the same for all the workbooks, holding headcount and percentage per group.
and a menu overview that is there for a summaryof info.


when I work out the redesign, it needs to be simple and easy for people to use. the system at the moment is a mess to use, and mistakes happen to much, when they input info to the wrong week