Joe, maybe this will help:
http://www.officearticles.com/excel/...rk sheets.htm

If you have difficulty because totals are "at the bottom" but not in the
same row, consider inserting a row at the very top, and using row 1 as your
totals instead.
************
Anne Troy
www.OfficeArticles.com

"Joe" wrote in message
...


I would like to summarise 20 sheets in the same workbook.
I have a list of data in column A and then 6 lists of totals in columns B
to
G, on each sheet.
I would like to add together the totals e.g. all the totals in column B
together from each sheet, identified with the data in column A
Although the data in column A is similar it is not identical and on the
same
line on each sheet. The summary sheet has all the data from column A.

I started to use Vlookup putting the data into new columns on the summary
sheet, and had 120 columns 6 from each sheet then just us a basic sum when
all the data had fed into the summary sheet, but this proved to make the
workbook really slow.

has anybody got any other idea?

Thanks