If you realign your data on each sheet, will the values have the same cell
address on each sheet?

You could create a formula similar to this if all the data was in say D50:

=Sum (Sheet1:Sheet30!D50)

Post back if your question is more complicated.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"jkiser" wrote in message
...
I have a workbook with a large number of worksheets; on each worksheet is
an
array of data. I'm creating a summary worksheet to sum all of the other
worksheets. The problem is that all of the worksheets aren't
aligned....the
data to be added is all in column "E" but on its on a different line on
every
sheet.

Each of the data lines does have a common identifier so that I can use the
V-lookup formula to find the data to be added, but with so many sheets, it
would be a very, very long formula.

Question, if I make all of the data arrays the same size, can I use the
Vlookup formula across multiple worksheets....if "yes", how?

If not Vlookup, is there another means to do it?

Thanks