I am using Excel 2003.
I have a sheet showing the Item No., Brand, Description, sales, cost, stock
of a branch. The sheet contains 2000 rows and 6 columns. I have similar
sheets from 4 other branches, but the rows do not match. I am looking for a
method to consolidate the data so that similar rows (i.e. rows starting with
the same item no.) come in one row, so that I may add up the sales and stock
figures of all branches for a given item no.

Can someone help???