Auto fill information from one selected cell

[jaz2021]

I want to extract information from one sheet to auto fill a purchase order (separate sheet) based on a selection of PO# (a single cell)

Can anyone let me know the best way to set this up?

I have a template for the PO already and I have another sheet with a heading matching each of the items on the PO.

I want to be able to select which row auto fills the PO template.

 

[jaz2021]

PO #	Job Number	Ordered By	Project Name	Phone Number	Email	Attention	Supplier	Delivery Address	Delivery Contact Name	Delivery Contact Number	Total $ amount exc GST
1​
2​
3​
4​
5​
6​
7​
8​
9​
10​
11​
12​
13​
14​
15​
16​
17​
18​
19​
20​
21​
22​
23​
24​
25​
26​
27​
28​
29​
30​
31​
32​
33​

	​ ​
	PURCHASE ORDER
	Date	21-July-2021		PO#: ---
	From:				PO#	0	1
	Contact No.
	Email:
	ATTENTION:
	TO:
	JOB NO:					ORDER NO.
	PROJECT NAME:					SUPPLIER
	DELIVER TO:					MATERIAL:
	DELIVERY ADDRESS:
	LOGISTICS MANAGER
	LOGISTICS CONTACT NO:
	ITEM	COLOUR	LENGTH	QTY	UNIT PRICE	TOTAL
						TOTAL	$ -
						GST	$ -
	Notes:					TOTAL INC GST	$ -