Dropdown list to populate another sheet
 

I don't mind reading up a little, but am not sure where to start.


The basic idea is a questionnaire that needs the data for each question
dumping on a separate sheet for crunching - as different people do the
questionnaire, the data builds up like a list on the sheet.
I would like to create a dropdown list (can do this) that a user can
select an item and press either a hyperlink or macro to take them to
the next question (basically another sheet - can do hyperlink - not
macro) Hitting this button should also add their choice to a data sheet
as well as navigate them to the next question.

Can anyone advise the simplest way in which to do this please - or a
pointer to the functions macros needed to do this.

many thanks - appreciate any help at all :)