There are several solutions. but somwething like this should work:

First use Date-External Data- New database query and connect to your
Access database. Create a query that gets the required list onto a
sheet.

Now use a Combobox and referene the range of the query. If yoy use the
combobox from the "Forms" menu bar, you can even use the (defined) name
of the query, which will then always accommodate the correct amount of
rows.

DM Unseen