Are you always averaging the same cell from each sheet?

If yes,

Then

=AVERAGE(Sheet1:Sheet31!A1)

should work, where A1 is the cell you are averaging from sheets named
Sheet1 to sheet named Sheet31


--
NBVC

Where there is a will there are many ways.
------------------------------------------------------------------------
NBVC's Profile: http://www.thecodecage.com/forumz/member.php?userid=74
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=109718