Summing data from days to Months realtime

Hi,

I'm totally stuck at an impass and I'm hoping someone can help me out.

I've got a sheet that updates daily from the web and applies a new row of data that is datestampted with the day-month-year.

I need a formula that will recognize all the data from the same month, then sum it for use in a chart.

For a gold star, as new months are entered, new rows should be created to accomodate them.


I've attached a test sheet with what I'm looking for. There is a WEB_SHEET sheet which is where the data is that I refresh from each day, and a CHART_DATA sheet which is where I store the data for the chart from.

Thank you,
JNic