Thanks, but it is not working. Maybe I am dense or something.

All of my info is in cell E5 across the sheets. The sheets are renamed as
addresses. Should there be any ' in the formula?

"Gary''s Student" wrote:

=AVERAGE(Sheet1:Sheet63!A1)

will average all the sheets between 1 and 63
--
Gary''s Student - gsnu200786


"Steph" wrote:

I have a workbook with 63 worksheets in it. All of the worksheets are
formatted exactly the same. Is there a way to make a master sheet that will
average all of the worksheets and be in the same format and layout?