bring up a userform that searches

hello

is there a way that i can create a macro that would do the following:

Macro click

userform apears

on the userform
it would have a search bar
and a list box

on the search bar you can type the employees name
and then the list box would bring the closest result

then when you choose the name
you can click "ok" on the userform and all the information for the name chosen would apear on the work sheet

each time a name is chosen it would just replace what is on the sheet

i would be reallyyyy gretful if you can help me find the solution for the above
please

thank you in advance

Thanks for your help
that helped me alot
i reli apreciate your help