I'm a newbie here so I will try my best to explain my question.

I have a spreadsheet full of data that I do my monthly reports with.. On one sheet is the data by month, on the other is the dashboard of charts. Right now all of the charts reference the data from the other sheet and each month I have to go in the charts and select data and move it over to the current month. What i'm looking for is a formula that will allow me to go on the page with the charts and change the month, then all of the data changes to the current month.

Not sure if this makes any sense or not

let me know

Thanks