Combo Box Sorting Update Problem

Hi,

I am having a issue with a combo box giving me wrong values when i add information to a table after sorting it. Sorry this explanation might be slightly long winded.

eg.

Worksheet1

Id Name
1 aaa
2 bbb
3 ddd

Worksheet2

Comboboxs looking up range (Worksheet1,Name)



So i can select ddd from the combo box and that works fine. Now using a form i add a new IdNumber and Name to Worksheet1.

1 aaa
2 bbb
3 ddd
4 ccc

I then need to sort this data so it is in alphabetical order, which i can do fine. It now looks like so:

1 aaa
2 bbb
4 ccc
3 ddd

I then look back at my combo box in Worksheet 2 and instead of showing ddd like it did before it shows ccc.

How can i remedy this so that it continues to show the original value but allow the data to be alphabetically sorted?