Combine 80 sheets in one workbook

[bullit_nl]

I have a workbook with 80 sheets.

All sheets have the same layout with 13 columns.

On one sheet i want to totalize all 80 sheets on a other sheer i want to have total in one column so that i can put in my stock and get a new total.

Hope this is possible.

Thanks.

 

[dhExcel]

Try using Data, Consolidate.

 

[bullit_nl]

I'll try to explain my sheet a little more:

All sheets have the same layout with 13 columns. Each sheet is for a different supplier.

In column B i have the names of different articles. Always starting at B10.

In columns E - M, also starting at row 10, i have different quantities for the artciles.

These are calculated by formulas from the other rows and columns on that sheet.

I need to make one sheet that collects all the names of the unique articles from all sheets in column B and sum all quantities in seperate columns from all sheets columns E -M.


Thanks.