Mapping weekly Calendar with roste

[Mady4Real]

Hey people,

i'm quite new to excel and just currently switched my Job.. And after going through the processes i have decided to automate stuff as much as possible and for that i need your help..
Every week we have to uplaod the roster of our employees which are around 500, so that activity is taking a lot of time and effort.. for that i require a sheet, where a week can be mapped just by selecting month and week (1st week, 2nd week, 3rd week etc). And just by selecting the the shift from the list complete week can be mapped.. i'm not sure if i'm making any sense right now :D but i have attached a sample sheet.. Please help guys.

edit: i cant upload a file :/ posting a link as soon as i can

[Mady4Real]

http://dl.dropbox.com/u/73609976/Roster%20Example.xlsx