Autocomplete Form

Hi there :-)

I'm creating a Purchase Order Form that will reduce time spent adding in contact details.
What I'm looking to achieve is a form that will be printed with a few formulas allowing sections of the form to be filled out automatically once a singular company name (chosen from a drop-down list I created, currently with a 'Combo box ActiveX') then the rest of the form is filled out accordingly.

At the moment it's a bit of a mess, not too sure where I'm meant to put the ranges.
There are currently 2 sheets - Sheet 1 with the form, Sheet 2 with all contact information.

Have been googling far and wide for some sort of help, but I'm not the best Excel Wiz, so have resorted to posting a thread, (my first :-D)

Any help would be greatly appreciated, I have attached what I have so far.

Welcome to the forum,

Please see attched. I have dispensed with the list box in favour of data validation. See what you think.

Hope that helps

Dave H