Excel Help Required

[Whatever]

I have an excel spreadsheet with 3 worksheets, Purchase Order, Supplier, Products.

Purchase Order is where I want everything to be displayed so for example we can use the drop down to select the supplier, who's listed in the corresponding worksheet. Is it then possible to display the address of that supplier if I have one supplier per row and the address is in titled columns in the same row of the supplier worksheet?

Also if I enter products, product codes and their respective suppliers on the third worksheet, is it possible that once I have chosen the supplier  from the drop down on the purchase order that I can only choose products from that supplier to go on the purchase order?

Any help appreciated!

Paul