Range selection List with no blank cells

Hi all,

Trying to create a Drop-down selection list using Data Validation from a a Named rage but because the Range has blank cells, these blanks also come up in the Dropdown list.
This Drop-down list needs to allow for adding removing changing names so the names list could be hundreds of names, but exclude blank cells when using the Drop-down selection list.

Having read many discussions, it would seem Dynamic ranges and tables are involved?
Have tried several processes using OFFSET, UNDEX but just cannot seem to get my thinking logic around these functions.

Attached is my attempt.

Assistance please - No VBA.