Need help with list drop-down formula

[Tanner85toy]

I'm trying to set up a drop-down list.  (I know how to make the list).  I would like it to auto populate (based off my selection from the list) the adjacent cells in the row.  My info is coming from another work sheet in the same work book.

[#2]

If you have Office 365 then XLOOKUP will be a good fit here https://accessanalytic.com.au/xlookup/

Alternatively if you don't have XLOOKUP or you need this to work on all versions of Excel then checkout INDEX MATCH https://accessanalytic.com.au/index-match/

[#3]

@Tanner85toy 

I've attached an example