Vlookup & index

Hi everyone,
Im hoping you can give me a hand here.
ive spent the last couple days re doing an old order listing we have that will be good till the next order ( 2 yrs ) and due to the increased size of the order i had to remake it.
over the course of the next 2 years items will be ordered multiple times.
For example:
4093226 is ordered 9 times in quantities of 4.

On the Master Sheet tab i have all of the orders inputted. A reference code for VLOOKUP, the Job Number, Item Number (Place Reference on Purchase Order) Part Number, Description,Qty for that order, Stock, Notes, Due Date,Purchase Order Number, General Supplier.

On the Cutting List tab i have the parts that require cutting at our factory but need to list all occurances of the required part.
In this case 4093226-02 which occurs 9 times. I need a formula that i can drag down and fill in the Job Number and Due Date & Price for other suppliers.

Im not very handy with excel but have a bit of an idea ( when i can get it working )

I would think INDEX would be the most appropriate but i cannot get it working across the 2 sheets.

Any help would be greatly appreciated.

Thanks a bunch in advance.

You could try this approach to extract all the multiple items for the Part No.
In a new sheet,
Assume the input for the Part No. will be made in cell A2, eg: 4093226-02
In B2: =IF('Master Sheet'!D2<>$A$2,"",ROW())
Copy B2 down to cover the max possible extent of data in Master Sheet, eg down to row 1000?
Then place
In C2: =IF(ROWS($1:1)>COUNT($B:$B),"",INDEX('Master Sheet'!B:B,SMALL($B:$B,ROWS($1:1))))
In D2: =IF(ROWS($1:1)>COUNT($B:$B),"",INDEX('Master Sheet'!K:K,SMALL($B:$B,ROWS($1:1))))
Select C2:D2, copy down to say, row 300? Col C will extract all the multiple Job Nos, col D extracts the Suppliers pertaining to the Part No input in A2. All data extracted will be neatly bunched at the top. You could then easily do a copy n paste special as values into the sheet: Cutting List as desired
---------------------------------
Any good? Wave it, click on the little star at the bottom left of my responses