Sort Inputs From List Into Table

Hello everyone,

I'm new here, but have often used the site to search for answers to my Excel questions.

I want to be able to input data throughout the year, while having formulas sort the data by month and company name, and put this data into a new table, under a single line. For example: Each time there is a new entry for Company 1, the "Volume" should be added to the running total for that month in the Output Table. The "Premium" in the Output Table should display a weighted average of all premiums for that month (entered in the Input Table).

I understand this sounds confusing, so I have attached an spreadsheet that makes much more sense than my explanation.

I really appreciate any help that anyone can provide.

Thank you in advance,

Sort Monthly Data.xlsx

That is exactly what I was looking for. Thank you very much!