|Sheet 25 is in the same workbook. On sheets 1-24, Column F has part numbers and Column K has the quantity required. Sheet 25 is being used to tally total quantities of materials required across the 24 other sheets. Column A on Sheet 25 contains material part numbers, Column B needs to be a total of the required materials across the other 24 sheets.|
Sheets 1 - 24 are parts lists for products my company manufactures.
For example, if sheet 1 has part number ABC123, quantity 3, sheet 7 ABC123, quantity 7, then sheet 25 should have ABC123 in Column A and 10 in Column B.