Drop Down selecting worksheet

Hi, I'm, trying to create a drop down list that by choosing, say a country,
will tell the workbook to send the data I type later to a specific sheet,
called Denmark etc.

DropDownList must be on the first sheet, called index which only is used to
type data in. The other sheets must be used for storing data only.

Denmark
Sweden
Norway

In the workbook I have as many sheets as I have country's

On top on this, I would love to have 5 different drop down lists working
together.

Confused? Well, I am [...]

Chris

well i ges u no haw to make the list, but u ned somthing else to fire
ur data to the sheets u chose in the list
fx. a commandbutton widt som kode to copy/paste ur data

dropdown-list working together what help do u ned here?