VBA for accept data on userform and display more data

Hi

I am wondering if this is possible in VBA coding/excel. I have attempted a few tries with code, and I am not sure it is. I have a userform (from a button on sheet 2) that I want to accept data on the top half, from a drop down menu. From there I go to sheet 1 match the selected data and get the rest of the 5 columns of data . Then return to the userform and display the data retrieved from the 5 columns on the bottom of the userform.

crude example:

initals (from drop down menu from data is col 1 of sheet 1): sm, ad, lr, mb, kd

select ad

goto sheet 1, match ad and get data

ad 112 w f 02 dis

on bottom of userform display

initals: ad
no: 112
race: white
***: female
dept: 2 manufact
status: disability

I believe it is possible to do this, but I may be missing code to make the dropdown menu work

Thanks