How do I populate an Order Sheet from a Product List using INDEX MATCH?

Hi all!

I want a function that is able to look down the quantity column of the Product List, and when it finds a value greater than 0, populates all the relevant data (Quantity, Product Code, Description and Unit Price) into the order sheet. As not all items will be ordered each time, there will be numerous 'blank' quantity cells. Would anyone have an idea of an index match function that could help? Thanks in Advance!

I have a product list on one sheet, such as this below.

Quantity	Product Code	Description	Unit Cost	Mark Up	Unit Price
1	AAA123	Description 1	$10.00	$4.00	$14.00
	BBB456	Description 2	$50.00	$20.00	$70.00
4	CCC789	Description 3	$30.00	$12.00	$42.00
	DDD123	Description 4	$20.00	$8.00	$28.00
2	EEE456	Description 5	$100.00	$40.00	$140.00

I want to be able to take the quantities selected and populate the order sheet to look like this.

Product Code	Description	Quantity	Unit Price	Total Price
AAA123	Description 1	1	$14.00	$14.00
CCC789	Description 3	4	$42.00	$168.00
EEE456	Description 5	2	$140.00	$280.00

Thank you! - Hayden

Put this on A9 and copied down and cross

=IFERROR(INDEX(A$2:A$6,AGGREGATE(15,6,(ROW(A$2:A$6)-MIN(ROW(A$2:A$6))+1)/($A$2:$A$6<>""),ROW(A1))),"")

Thanks Azumi, works perfectly!