Double VLookup

I am looking for a double VLOOKUP to search by a part number, look on a seperate spreadsheet for the same part number and return the quantity to ship on different dates....

Please see attached example.

All i am trying to get out of this is have the formula look at a part number, look through all the dates and quantities that this part is suppose to ship (yellow section on example) and return the correct quantity on the correct ship date.

Thank you for your help in advance!

Thank you, this worked perfect!!!! Now I have to find out how to hardcode the formula. What I mean is lets say the formula I am using is:

=SUMPRODUCT((PLANT!$D$5:$D$31=$B62)*(PLANT!$A$5:$A$31=D62),PLANT!$E$5:$E$31)

I have the original problem in its own "summary" worksheet. The DATA for the spreadsheet, (the yellow in the example), I download daily into a .CSV file. I wanted to just copy over the tab from the CSV file and name it the EXACT same thing everyday so the worksheet will populate and the formula's will be functional.

Unfortunaly, when I deleted sheet#2 and re-imported a new one and renamed it the EXACT same way, it made the REF# error.

Is there a way to "hardcode" the name (in this case "PLANT"), so that even though I may not have a reference sheet to reference, the formula would maintain the correct reference name, so when i do copy the tab over the next day, it will self-populate?

I have attached a rought copy of the spread sheet.

My goal is to get a BLANK worksheet, where I and just copy in the "Plant" tab and Bam....the worksheet populates.

I have input the formula, but its still not populating...any ideas?

Sorry...I found a typo....and it works now!!!!

Thank you so much for your help on this! I really appreciate it!