Changing Excel Graph Series based on Tab Title

[CDelSignore]

I'm working on a spreadsheet that will chart data monthly. I want to give each month it's own tab. I've set up a tab (Current Month) that shows data on - you guessed it! - the current month's data, using the Today() function in A1 for the sheet to determine the current month. I created all my data tables and graphs (countifs, indirects, etc) and it's great. I've put the graphs together that I want to show. Everything gets hidden so only the graphs show (past the first row). When I copy/paste into a new tab, and put the month name in A1 instead of the Today() function, the data updates appropriately. But, the graphs are still indexed to the 'Current Month' cells.


For one series, the data is located here: =Current Month!$H$4:$H$21. Is there a formulaic way to have the sheet reference change to reflect the current sheet? I want that data series to be =February!$H$4:$H$21. I want the sheet name in that to match the month put in A1, so all I'll have to do is change the month in A1 and everything will be hunky dory.