Help needed to get values from different sheet and sum if the value in one column matches

[szpt9m]

Hi All,
I have a workbook with 3 sheets each having 2 columns!

Sheet1:

[TABLE="width: 128"]
<TBODY>[TR]
[TD]Col-A</SPAN>[/TD]
[TD]Col-B</SPAN>[/TD]
[/TR]
[TR]
[TD="align: right"]3245688</SPAN>[/TD]
[TD="align: right"]12</SPAN>[/TD]
[/TR]
[TR]
[TD="align: right"]4567893</SPAN>[/TD]
[TD="align: right"]13.5</SPAN>[/TD]
[/TR]
[TR]
[TD="align: right"]1342567</SPAN>[/TD]
[TD="align: right"]15</SPAN>[/TD]
[/TR]
</TBODY><COLGROUP><COL span=2></COLGROUP>[/TABLE]


Sheet2:

[TABLE="width: 96"]
<COLGROUP><COL style="WIDTH: 48pt" span=2 width=64><TBODY>[TR]
[TD="width: 64, bgcolor: transparent"]Col-A[/TD]
[TD="width: 64, bgcolor: transparent"]Col-B[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]3245688[/TD]
[TD="bgcolor: transparent, align: right"]13.7[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]2139475[/TD]
[TD="bgcolor: transparent, align: right"]45[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9875768[/TD]
[TD="bgcolor: transparent, align: right"]23[/TD]
[/TR]
</TBODY>[/TABLE]

Sheet3:

[TABLE="width: 96"]
<COLGROUP><COL style="WIDTH: 48pt" span=2 width=64><TBODY>[TR]
[TD="width: 64, bgcolor: transparent"]Col-A[/TD]
[TD="width: 64, bgcolor: transparent"]Col-B[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]142234[/TD]
[TD="bgcolor: transparent, align: right"]23[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]24563[/TD]
[TD="bgcolor: transparent, align: right"]56[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]156789[/TD]
[TD="bgcolor: transparent, align: right"]13.2[/TD]
[/TR]
</TBODY>[/TABLE]

Now i need to search in all 3 sheets, if column A value of one sheet matches with another sheet, then i need to sum the values in column B. if it doesnot matches then i just need take those values and put it in my resultant sheet.
so the result from the above example will be as below:

  [TABLE="width: 96"]
<COLGROUP><COL style="WIDTH: 48pt" span=2 width=64><TBODY>[TR]
[TD="width: 64, bgcolor: transparent"]Col-A[/TD]
[TD="width: 64, bgcolor: transparent"]Col-B[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]3245688[/TD]
[TD="bgcolor: transparent, align: right"]25.7[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]4567893[/TD]
[TD="bgcolor: transparent, align: right"]13.5[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]1342567[/TD]
[TD="bgcolor: transparent, align: right"]15[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]2139475[/TD]
[TD="bgcolor: transparent, align: right"]45[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]9875768[/TD]
[TD="bgcolor: transparent, align: right"]23[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]142234[/TD]
[TD="bgcolor: transparent, align: right"]23[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]24563[/TD]
[TD="bgcolor: transparent, align: right"]56[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]156789[/TD]
[TD="bgcolor: transparent, align: right"]13.2[/TD]
[/TR]
</TBODY>[/TABLE]

Since here the first value in column A of sheet 1 matches with that of sheet 2, the values in column B is summed up.. all other values are placed as it is..
Thank you,

 

[szpt9m]

waiting for someones help here!!