I am looking to move data from one workbook to another and consolidate
data.

Here is what I have
A = Item #
B = Catalog

Row 1 is A = 1234 and B = 1
Row 2 is A = 1235 and B = 2
Row 3 is A = 1236 and B = 1

What I want
New Workbook
Row 1 is A = 1234, 1236 and B = 1
Row 2 is A = 1235 and B = 2

Thanks,
Jay