I am in need of creating a form with drop down boxes that can be filled in
easily.  Then I am in need of it taking the information inputted and
accumulating it in a worksheet which I can use as an analysis which would
have run over a number of month..... that sounds confusing!

Let me explain:
I have a number of employees that have 'Audits' completed on them to ensure
correct procedures and quality.  They also show if training is needed and
where performance is low.

I am wanting to get this form (which is currently on paper) into Excel (or
what ever will be best to use) and create drop down boxes that can be filled
in easily. Each question has a number of set answers, but mainly its either
'correct' or 'incorrect'.  When this form is filled in, it then adds the data
to a spreadsheet so it can be analysed.  This spreadsheet will be for
individuals, so it will accumulate the data gathered on the employees over a
few months.  I guessed that a drop down box with their names in will be
needed to link to each persons accumulate spreadsheet and then it can all be
linked together to give an overall picture of all the employees together.  
Also I need it to be on a monthly basis so I guess there would be a month
drop down box too.

I am a tad overwhelmed! I am after the basic form making and linking to a
spreadsheet.  The rest should be simple after the initial form and links are
inputted.... but how to do it?  I feel I might be looking in the wrong place!

Can anyone help?

Iduna