Are all these sheets in sequential order? If so try this:

=SUM('(1):(31)'!A1)

Or, you can create a worksheet "sandwhich". Create an empty sheet named
Start and place it to the left of sheet (1). Create another empty sheet
named End and place it to the right of sheet (31). Then use this formula:

=SUM(Start:End!A1)

Any sheets within the "sandwich" will be included in the sum.

Or, this:

=SUMPRODUCT(N(INDIRECT("'("&ROW(INDIRECT("1:31"))& ")'!A1")))

Biff

"Qazi Ahmad" wrote in message
...
My one Excel file have 31 worksheet i want Cell A1 data of all 31worksheet
in
one worksheet with sum furmula (Summery worksheet) sum of all 31 worksheet
cell A1 data in my summrey cell. i know only with + Exp
=SUM('(1)'!B5+'(2)'!B5+'(3)'!B5+'(4)'!B5+'(5)'!B5+ '(6)'!B5) till 31
worksheet
I WANT SUM WITH RANGE

Thank you