need help with importing data from another worksheet

i am compiling a customer template for product purchases. i have made 2 worksheets 1 for customers and one for products.
i need someone to put in drop list so when i enter products in customers i have a list from the second sheet?
also would like product description to auto fill when i do this.
i am new to this so all help is greatly appreciated.
file is attached and if you have questions let me know.
thank you all in advance.
hat

AttachmentSize
Customer Template.xls81.5 KB