Sort dropdowns aphabetically

[Celticfc]

Hi,

I have a 100 dropdown lists in column A (each with it's own OFFSET's).

Is there a way to sort my Dropdowns based on its value?

I.e.

Dropdown in A1 has John;A2 has Alice.

How can I sort these alphabetically, where dropdown will swap places obviously?

Currently I can't do it, assuming they do sort but revert back due to their offset formula?

Is this even possible?