Pulling records matching two criteria and inserting those records into an existing list

Hello. Right now I have a great setup to pull Class Name and Discount Rate to determine if a Class should be purchased this week based on Discount Changes from last week to this week. Certain Class Names from my purchasing lists require a list of SKU's and Descriptions to be sent from that class to be added to my purchase order requests. Right now that process is done manually. I would like to automate it.

Here is the current process:
1. A Discount Sheet is emailed to me containing a list of Class Names, last week's discount rate, and this week's current discount rate for various products in PDF format.
2. That PDF is converted into Excel and then pasted into the "Discount Sheet" sheet within my purchasing workbook.
3. My IF/AND/INDEX/MATCH formula compares my list of Class Names and my desired purchase discount ("Markdown%") to that Discount Sheet.
4. The formula returns a Yes or No. If last week's discount was below my Markdown% and now this week's discount is equal to or greater than my Markdown%, the result is Yes. If this week's discount is below my Markdown%, the result is No.
5. Using a Data Sort the "Yes" Class Names off of the "Discount Sheet Processing" sheet are sorted out from the "No" Class Names to create a purchasing order.
6. The Class Names to be purchased sometimes contain a note stating "See SKU List". If a SKU List is required, then I cut and paste that SKU and description from my SKU List that coincides with that Class Name and the Discount Rate of that class' purchase order.
7. That list is then emailed to my supplier.

What I want to do is write a script/formula that will automatically pull the correct SKU's from the SKU List based on the Class Name and Markdown% from my purchase order only if the Notes state "See SKU List". The "Desired Results" sheet in the attached workbook gives an example of the desired output format.

Thank you very much in advance for your input.

Hello,

Because the Binding class contains "See SKU List" in the class notes. Basically those are the only SKU's I wanted to purchase from that class. The SKU List only contains those SKU's because I have narrowed it down to those. I have a lot more classes that I purchase than those listed in the sample file. In the sample file you will see 4 out of 8 of the classes have "See SKU List" in Column D. When those classes come up on a purchase order that state "See SKU List" in the notes, I would like the list of SKU's I want automatically added to the purchase order, inserted within column D below the notes for that class(only the ones at that discount level-the discount percent is secondary in match criteria.

Any clearer now?

Thanks.

David

Also to clarify calculators. Those came on as a Yes for purchasing because this week's discount rate on the Discount Sheet was at 50%, in turn meeting the criteria for purchasing. No SKU List is required because of what I mentioned above.