help with a worksheet question
 

i am designing a worksheet for a company that hold's football tryout's... the
worksheet will be a record of each player's statistics'... is there a way i
can design one page - say a dashboard where their info is entered in and then
you hit a submit button and the record is stored - only to be recalled with a
certain key/ drop down menu- for a particular position... example...20
player's entered ( 4 of them are quartback's ) in a drop down menu for each
position ( qb, rb, ol, wr ) when i choose the qb from the drop down it will
give me a choice of the 4qb's...
i hope ive made some sense...
thanks
trey