Dennis

Use of the INDIRECT Function is handy for incrementing sheet names in
formulas.

e.g.

Insert a new sheet and name it Namesheet.

Type your sheet names(other than Summary) in a list from A1:A10 (assuming 10
sheets)

In your Summary sheet enter formula like

=INDIRECT(Namesheet!A1 & "!" & "$A$4")

Drag/copy this down the column to return contents of A4 from each sheet in the
list from A1:A10


Gord Dibben Excel MVP

On Sun, 8 May 2005 12:57:49 -0700, "Dennis-winclad"
wrote:

I'm after a formula that will summarise several worksheets into a summary
sheet, within a workbook, at a given cell location.Possibly one which will
either be written to one cell, and 'copied' by dragging to other rows, and
columns, rather than clicking on each woksheet, to get original cell location