I'm trying to add together the total number of products used for several technicians in a workbook, and I don't know how to add all the data together. Its entered in with the part number, the last date it was ordered and the running total for that technician for the year, I'll attach an example.
I want to know how to make a table that will find the product number on every sheet in the workbook and add up all the totals on the right. I know how to do it when the sheets are formatted the same and have the same product numbers listed downwards, but I was given this sheet from someone else who just added parts in randomly for each technician.
