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