I have a Contact list with the following Header row
A1 - Account No.
B1 - Customer
C1 - Street1
D1 - Street2
E1 - City
F1 - State
G1 - Zip
H1 - Phone
I1 - Terms

I would like to create a sheet, where i can just key in or select the name of the customer (B1) and the corresponding data in all other columns Fills up. Can anyone please show me how to do this.

Thank You.