Hi all -
Thank you so much for your help.
I am trying to select a few different cells from multiple/different sheets in my workbook but name them in "Name Manager".
Then based on that "Name", you it as an axis in a chart.

So far I've tried entering the following in Name Manger to select the cells but nothing seems to be working when I select the name in the series for the axis in the chart:

=('2009'!$AA$9),('2010'!$AA$9)
='2009:2013'!$AA$9