Macro to Reorganize Data

[Mamagregory]

I'm trying to come up with a Macro using the attached data of orders from an online market (this is just a sample, the real data may have up to 1000 rows) to create a new sheet in the workbook that will have the total number of items each farmer needs to bring.

So on the data it is listed by customer order but on the new sheet it will be listed by farmer total.

As a simple example you might have:

customer a order number 1: 3 potatoes 1 broccoli farmer a and 2 peas from farmer b
customer b order number 2: 2 peaches from farmer c and one potato from farmer a

And the new sheet would say

farmer a 4 potatoes 1 broccoli
farmer b 2 peas
farmer c 2 peaches

It would be nice if this could be split out by columns as in the example file (the second file attached) or any way you can suggest. Ideally we want their email to be pulled from the lookup table to make it easier to email each farmer each week with their item totals. Does anyone know of a good way to automate the emailst too?? Can you use a macro for that?

The challenging part is that multiple customers may order from the same farmer on different lines but everything needs to be added together.

Any advice??

Thanks!