Referencing multiple cells based on a single cell input

[77F150XLT]

This is really poor wording, but I'm looking for a way to automatically reference multiple cells based on the input of a single cell. I have two sheets in my excel work book, sheet one will have all the manual entered data, sheet two will be a permanent reference. I want to be able to type a 4 digit "Code" into one cell and have it fill the name, and address of the cells from the second sheet. I have the cell I want to input shown on the sheet 1 with a red arrow, and the cells I want to have automatically input shown with black arrows. sheet two is the cells that contain all the data that I want transferred to the cells in sheet one. Thanks for any help, this should be stupid easy, I'm just drawing a blank. 

[#2]

@77F150XLT 

There's a few ways to do it.

Here's XLOOKUP.

[#3]

@Patrick2788 

Unfortunately i'm on the semi annual update plan with office 365 so I don't have access to the xlookup function yet. is there another way to do it? Thanks a bunch.

[#4]

@77F150XLT 

Yes, your base formula (going off my sample workbook) becomes:

=IFERROR(VLOOKUP($A2,Retailer!$A:$F,COLUMN(B1),0),"")

Fill handle it across and down as needed. Make the column references ($A:$F) specific to your range.