Autocomplete-Would like to autocomplete while bringing data ?

Help me i still cant get just where i need too

Would like to autocomplete while bringing data from another sheet as the data
list will be rather large

See attached front sheet Cell A7, can this be made in some way auto complete , or can this be tackled another way ??

I dont want to bring all the data into this front sheet