Excel - Storing entered data

Hello,

I am a relative novice who knows what they want to achieve but is unsure how to get there.

I work in a school and want all staff to complete a Staff ICT skills audit (ironic that I am on here I know! but the level of knowledge necessary is FAR FAR less than tat which you guys have!!!!)

For arguments sake I have in three columns (BCD) in B I have a Question code, in C2 I have used data validation so that all the names of the teachers will be listed and they choose their name from the drop down. From C3 to C119 I have the questions and in D3 to D119 I have data validation drop down lists for staff to choose 1 2 3 4 5 based on strengths/confidence, I have also Conditionally Formatted these cells for colour coding purposes.

Using Excel 2007 I want staff to select their name in C2 and complete the questionnaire while the scores they enter are recorded in another worksheet which (as it will be stored on the shared network) then builds to record all the unique entried made by each staff.

I appreciate that 100+ questions may require a lot of data to manage; therefore I have created in cells H12 - T29 a summary table (the questions are subdivided into 13 sections) which records the % of 1s 2s 3s 4s 5s that have been entered in each section and it may be that it will be easier (I'm guessing) to record the percentages that have been entered in a separate worksheet - but will i be able to go back in and see individual question answers?

I appreciate that this is may be very confusing but hopefully the solution isn't. I have uploaded a screenshot which will hopefully explain the above to Imageshack - the direct link is**** http://img191.imageshack.us/img191/4483/audit.jpg **** if you would be so kind to look at it - it is genuine!

I'm sure I will have more questions but any help in this would be great! and I will be extremely grateful!!

Any suggestions or improvements to my idea would also be gratefully received

Thanks

MC