Dependent on drop down list column will change

Hi all,

Very new to this, anyway.


I have 3 options on the drop-down list.
If I choose option 1, I want a column to change to replicate a column on sheet 2,
Same with option 2 and 3.

The same column needs to change in sheet 1 relevant to the drop down list which is related to the column on sheet 2.

I have attached the spreadsheet I am working on.
Column E on sales Form needs to change according to whats chosen in cell B15 on sheet sales form.
The change is on sheet 1.
So if i choose "delivery note" the data should update from column B in sheet 1
"Sale Order Request Form / Purchase Order" use column C and so on.


Hope someone can help.

Thanks in Advance.