holiday planner

i am trying to build a holiday planner, i am a beginner @ excel and i think i took on too much, but anyhow,

i am trying to get a few things happenning

1, have a main sheet to input holidays date from, date too which is easy enough but on sheet 2 i would like to take the info from sheet 1 and put it into a month with a max amount of persons of 10 having holidays at any one time else it would read space Free.

2 from a main sheet of rotas i have have got i would like to have total hours in week worked but this would be easy if it was day shifts but its nightshifts i.e 22:00 - 06:00 =(8) 7 hours with a hour taken off for dinner then with that information i would like to get holidays left to take in hours and days taken from the main holiday hours on main sheet all holidays input manully,

and a few other things

if anyone can help me with stting this up or some software/freeware already avaliable please contact me