Holiday planner

As this is my first post hello everyone :-)

I have a planner to track numerous staff across different roles, I want to be able to enter all the holidays in the planner then have a summary sheet of each weeks annual leave via a "week drop down menu" any hints or tips would be greatly appreciated.

Thanks Andy