Summary of sales by suppliers

Hello,
I apologize in advance for my bad writing in English.

I would like to find a summary of sales per supplier.

Example:

Customer A and B ordered suppliers 1 and 2

I would like to be able to output an Excel file a week with the summary on provider 1 with the orders of the client A and B detailed and the total.

thank you very much