I have a workbook with many different worksheets, all
have the same basic data (5 columns, many rows) Column A
is the part number, and the rest are qty's (sales,
purchase order, ect) there are many duplicate part
numbers in column A that I would like to sum up or
combind some how. Is the a macro that could fly through
all of the worksheets doing something like this?

thanks much
Brian