summery of several worksheets

[Bilal]

Dear support team,

I have a workbook that contains several worksheets, in
these sheets I have a data that I need to transfer to
summery sheet, example:

work sheets, sheet1,sheet2,sheet3,totalsheet,

sheet1 cell A1=100
sheet2 cell A1=200
sheet3 cell A1=300

In the total sheet I need a formula that transfer these
data directly, my exisint formula does not change sheet
number, sheet number is fixed !!

Thanks

 

[Frank Kabel]

Hi
not quite sure but try
=SUM('sheet1:sheet3'!A1)

 

[Gord Dibben]

Bilal

On summary(total) sheet in cell A2 enter........

=INDIRECT("Sheet" & (ROW()-1) & "!A1")

When copied down, the Sheet1 will increment.

Change the ROW()-1 if you start in a different cell.

Gord Dibben Excel MVP