Hi,

I am wanting to concatenate a set of text to create a formula. I have done
so below.

=CONCATENATE("=MAX('",O1,"'!A3:A65536)")

The result is: =MAX('2009'!A3:A65536)
....but it treats this as a text string when I try to use INDIRECT

Cell O1 contains the year minus 1. In this case O1 = 2009. All of my
worksheets are named as a year e.g. 2007....2008....2009...2010. I am
entering this on sheet 2010.

Now the real question: How do I make another cell evaluate this string as an
actual formula and spit out the highest number for A3:A65536 from sheet 2009.

Thanks and Happy New Year!