hello.
I am looking for a help with my INTERNET store.
Currently all order comes via email. I copy and paste information from that email into inventory software to create invoice. I am trying to automate it somehow. The problem is, that INTERNET store has drop down options. That drop down menu is creation a mess with item number location in excel. I am looking for any solution to dig that item number and have it A=qty, B=item number.
here is the part from the email.

Qty SKU Product Name
1 OILFILTER-PACK Honda Genuine Oil Filter 6 & 30 Packs For Most Models
* Unshipped

Quantity: 6 Pack 15400-PLM-A02 X6

1 AIRFILTER-CRV Honda Air Filter CRV
Unshipped

Year: 2017 EX, EX-L, Touring 17220-5AA-A00 -$4.51

1 WIPERINSERTKIT-CRV Honda Front Windshield Wiper Inserts CRV
* Unshipped

Year: 2017 76622-TDK-J01 & 76632-TZ3-A03 +$0.48

5 HONDA-TRANSFLUID Honda Transmission Fluid
* Unshipped

Transmission: HCF2 08200-HCF2 +$2.86

1 90471-PW7-A00 Honda GASKET 10MM
* Unshipped


the final result should look like that. Price does not matter.

6 15400-PLM-A02
1 17220-5AA-A00
1 76622-TDK-J01
1 76632-TZ3-A03
5 08200-HCF2
1 90471-PW7-A00


I have a master list with all item numbers to match in another sheet.


Please let me know if you have any questions.
Thank you very much.