Not sorted in the sense that they be in alpha order.

Let's take the bracket lists as an example.

On sheet Input Lists, the named lists are in a certain order:

N2 = BracketList_A
O2 = BracketList_B
P2 = BracketList_C

The way the validation formula works:

=CHOOSE(MATCH(AC18,BracketLists,0),BracketList_A,BracketList_B,BracketList_C)

The Match function returns the number of the lookup_values RELATIVE position
within the lookup_array. The lookup_array is the named range BracketLists
that refers to Input Lists!N2:P2.

Let's say that AC18 (the lookup_value) = BracketList_B. The Match function
will return 2 because BracketList_B is in the 2nd position of the
lookup_array. If AC18 = BL_A then Match would return 1 because BL_A is in
the 1st position. BL_C is in the 3rd position. The result of the Match
function is then passed to the Choose function.

The Choose function also works based on position. Let's see how that looks
AFTER the Match function has passed its value:

=CHOOSE(2,BracketList_A,BracketList_B,BracketList_C)

The 2 is the index_number argument. That means to return the 2nd
value_argument which is the dynamic named range BracketList_B. If the
index_number was 3 then BL_C would be returned. If the index_number was 1
then BL_A would be returned.

So, to put it all in a logical sense:

The order of the items in the Match lookup_array MUST be in the same order
of the Choose value_argument (or vice versa) otherwise you'll get the
incorrect list appearing in the drop down.

Biff