Calculating Cost Per Month?

I am trying to create vba macro that allows me to calculate cost per month.

I have created a basic table with two columns

Cost
Month

200
Jan

300
March

150
Jan

470
April

150
March

I have another sheet , that has two columns

Month - Cost
Jan
Feb
March
April

I am trying to sum up the value on sheet1 and input into sheet2 on the allocated month.

So far logic , that I have came up with is.

I create a For loop statement that looks column and sort each month into an array.

Than the second loop will use the array to find the cost with the allocated array value to sum it.