Updating Charts with a macro help sought

Hi All,

I am trying to create a macro to update a series of charts on a monthly basis but am having trouble.

Each month on the spreadsheet I am working from I add extra rows for the month just completed and then reference those new rows in the charts at the bottom of the page. Currently I have to do that manual process of adding the new rows and then updating the chart to reflect the fact the source data has an extra row included. What I would like to do is have a macro that adds the extra rows, copies the formulas from above and then updates the charts with the data in the new row.

I have tried using the record option but obviously this only works for whatever month I am record on (i.e. if the last month is row 20 I add a row 21 and copy the formulas down but then next month the last month is row 21 but the macro adds a new row 21 rather than a row 22 etc)

I have created a little example of what I am trying to do in the attachment, if anyone is able to help me you are going to literally save me hours a month updating various tabs that are set up like this...

Thanks,
Tony