I have a sheet that includes a dropdown list, what i would like is when i
pick a word form that list it populates data in another cell,
The list is in cell B3, i then want it to look for the correct list on Sheet
3 and populate that information starting in cell A7 down

I think it needs a lookup but if there is an easier way I would appreciaite
some guidence

Thanks in advance