I need to set up a vacation worksheet(s) to track vacation. I need to do one
for each employee (30 employees) and a consolidated one so the boss can see
at a glance the days off in any one month (or year).

the individual ones are not a problem because I can insert the hours taken
there. I could do a different worksheet in the same workbook for each
employee. It is the consolidated one that is giving me trouble.

The present consolidated one is a monthly one but if I use that i would have
12 different consolidated worksheets in addition to a yearly worksheet for
each employee.

Any ideas how to do this? (and if someone wants to share their spreadsheets
as examples, i would be more than grateful!)