Hi! I have what I hope is a simple problem.

I've run into an instance where I need a cell to be referenced based on the month. For example,
in July, the cell would be 'Sheet2'!AC7
In October, the cell would be 'Sheet2'!AC10
etc.

Is this possible with something along the lines of
'Sheet2'!AC...MONTH(TODAY())
or
Cell("Contents",'Sheet2'!AC...MONTH(TODAY()))

Thanks in advance