An existing list of data needs to be linked as a "dropdown list" into another
sheet and a range of cells. The dropdown list should have the feature of
"Auto completing the list" instead of the normal "Validation / List" function
where the data remains fixed in the dropdown list.

Example "some items in a stock list needs to be inserted into another Excel
sheet with the aid of a dropdown list."
Thousands of items are in the list and to browse all without an "Auto
complete function" is not practical.