Hi There,

I've got a tricky one here, and I'm not sure if anything can be done about
it. Here's the situation...

I've got a workbook that I use to track the number of proposals my company
writes each month. There is one tab for each month, labelled with the format
mmmm yyyy (i.e. November 2009, December 2009, January 2010, etc.) and a
couple of summary sheets that reference data from each of the months.

I need to start a new summary sheet that only looks at the last 6 months,
excluding the current month, (so during March 2010, I need it to draw data
from September 2009 to February 2010 tabs. The data that i need is in the
same cell on each sheet.

Is there a formula that I can use that would automate this?

If anyone has any advice, I would very much appreciate it.

--
David