assembling manufacturing orders in Excel matrix with macros

[Salad Fingers]

I have to create a file assembling export orders in order to facilitate planning of their production.
I have the following information in my data sheet:
Row A : # order
Row B: Name of client
Row C: Country
Row D: Material
Row E: Bottle size
Row F: Quantity
Row G: Status with a drop down with options (completed / waiting for materials / materials are available)

I would like to create a matrix which aggregates order quantity in a matrix where in column A are the Material and as a subtotal are the Bottle size. Then in the fowling columns are the Country and as a subtotal are the # Order.

I also need to have a filter in my matrix in order to sort through Status and Country. Lastly, there needs to be a Refresh button to add the new orders when they are added in my data sheet.

I have attached a screenshot of how the final result should look like.

Thank you in advance,
CHavdar

 

[My Aswer Is This]

Excel does not have a:
Row A : # order
Row B: Name of client
Row C: Country

Excel has columns A and B and C

So do you mean Columns A B and C
Or Rows 1 2 and 3

 

[Salad Fingers]

Excel does not have a:
Row A : # order
Row B: Name of client
Row C: Country

Excel has columns A and B and C

So do you mean Columns A B and C
Or Rows 1 2 and 3

I meant Columns A B and C

 

[My Aswer Is This]

Thanks for that clarification.
This is beyond my knowledgebase.
I will continue to monitor this thread to see what I can learn.