Count and transfer

I have a spreadsheet. On Tab 1 "BULK", I enter in an item #, Item tag weight, and item actual weight. For the same product there can be multiple item #s. On Tab 2 "SUMMARY", I combine each item # a...