Questions about dealing with drop down lists - data validation

Hello all,

Another in the "I have never done this before and don't know where to start" series

data validation and drop down lists?

I have a worksheet ("Constants") that contains a list of values that I want to reference in another tab via a dropdown list.
The length of list is constantly changing (adding new customers for example) however I can always calculate the start and the last entry row values for the list if I need to.
I have a data entry tab with a cell that has the "dropdown list" referenced via data validation. (say cell D3)

So far so good

Now my questions,
q1. can I always start the dropdown list display of options at the start of the range of names available, if so how
q2. is there a sort of "typeahead" feature that allows me to type a couple of letters and position the display at that point in the list of options.
q3. I finally select a name from the list and it is then displayed in say cell D3. Is there a "vba does the heavy lifting" option to know which row from the list of customers that the selection was made.

I am happy to post a work in progress workbook if that will help, I think these are general "how do I do "stuff" questions rather than specific to my workbook

I hope I have explained my questions adequately

Jmac1947 (and still learning)