Hello. I have a workbook with 12 sheets. In the first one I have in column A:
x , y, z, x, a, z ....and in column B: 100 $, 300 $, .... In the second sheet
I have in column A: x, a, b, c, y, x.... and in column B: 200 $, 400 $....Ans
so on to the 12th sheet. I want in the 13rd sheet in the column A to have x,
y, z ...(it's not important the order ) and in column B to have sum from all
the sheets for x, y, z.....I want to put an accent: in the sheet values from
column A can repeat.

ex:
sheet 1
A B
1 x 100 $
2 y 300 $
3 z 100 $
4 x 200 $
4 ....

sheet 2
A B
1 x 100 $
2 a 300 $
3 b 200 $
4 a 100 $
5.....

sheet.......

sheet 13
A B
1 x (sum sheet1 + sheet 2+ ....sheet 12 )
2 y (sum sheet1 + sheet 2+ ....sheet 12 )
3 z (sum sheet1 + sheet 2+ ....sheet 12 )
........

thank u,