Yeah, array function; control+shift+enter. I got it as soon as I hit send.

What I want to do this is add a report page to the front of a workbook that
will summarize the information from the next six pages. The thing is the
next six pages are monthly reports so each month a new page is added right
under the front page.

Right now there is the Six Month Report (11/05-04/06) but at the end of this
month a new page will be added and the Six Month Report will be for
(12/05-05/06).

The report is an exact replica of the monthly reports except for the data.

Is there a way to write the formulae to take the next six sheets without
specifically naming what those sheets are?

Ben Karlin
St. Louis, MO