Dynamic range to update chart, multiple series

Hi there

I am creating a line chart with 2 series from seperate sheets. Each chart is populated from a single row on each sheet. Each sheet has the same account numbers running down column A. The date runs across row 1 in each sheet. One sheet shows, lets say, cash and the other cheque.

A chart needs to be created for many of these accounts so I am therefore, trying to automate this process a little. I have found a way to do this using dynamic ranges and a macro, however this only works for single series charts.

The only way I can get this to work for charts with two series is if the account numbers are in the exact same order in both sheets.

I have attached the file, any help would be much apprieciated
Thanks