For me it seems to work fine, however, I had to correct the typo:

In your dropdown list you have 'Charelville' and in your code you have 'Charleville'.

I also noted that the dates you have in the 'Dalby' tab don't really work and they are just integers.

Lastly I would recommend using tables for your data in the four tabs rather than named ranges, this way when you add new data, the table will expand and so will the range for the chart.