Steven,

I don't think you can sum across workbooks in the way that you can with
columns/rows and worksheets, as Excel does not know anything about what
workbooks would be constituted between the first and last. As such, I think
you would have to have a separate cell for each workbook that picks up the
amount, and sum those cells.

One way might be to hold a table of workbooks on another sheet, and
reference those in your formulae. That way you should be able to add others
without (many) changes.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"steven" wrote in message
...
Hello,

I'd like your help in the following. I have several workbooks with 13
sheets
each (monthes Jan-Dec and 1 that totals the 12). Every worksheet in all
the
workbooks is exactly the same. (cells in sheets do contain functions, some
are blank and some contain column/row headings).

I want to create a 13 sheet workbook which sums all the others month by
month and sumes the 13th sheet with the totals.

Is there a way to do this? functions or code does anyone have a solution?

Thank you,

Steven