Automate procedures with VBA or Macro- for dynamic data

Hi,
We're run a community gallery and have an app that handles the sales data. We download the transaction data at the end of each month (sample spreadsheet attached)in excel format.
The spreadsheet layout has columns for receipt no. name of item sold, and artists name. Each row is data on an item that was sold.

We'd like to create an automated system that can order all the rows together based on artist, and add up the total sales for each artist, and then send the monthly sales summery to each
arstist. (we have the mail merge/email part sorted via google sheets/docs).

The data will change each month, so the name of artists will likely change as well as the number of sales ie number of rows of data.

How do you create a system that can handle the the differring data for each month?

Have tried Pivot table, but that causes issues with the data merge/email.

Many thanks
Vin