Drop Down List with Linked Column

Hi there:

In my Sheet 1, in Column B I have a drop down list to select a name. I have used the data validation to select the name list from Sheet 4 that also has two more column associate with it, i.e., name code and group code. I am looking for way to show all three columns in Sheet 1 when I select the name from drop down menu in Sheet 1. I already have blank column next to name column with drop down.

Sheet 1
Name NameCode GroupCode

Sheet 4
Name NameCode GroupCode

Thank you in advance.

Paul