I'm trying to figure out how to pull specific data from all worksheets in a workbook and total them all on a single total page.
What I have is multiple shopping/prep lists for my menus and each lists the amount of each item to buy and prep. If I have more than one event to shop for, I currently have to bring all lists to the store and look at each of them individually for similarities and then add them in my head.
Example: 3 events need carrots, each with different amounts. I have one column that lists items needed and a separate column that lists a number of pounds needed. I want to create a "totals" sheet that will find the word "carrots" in the workbook and then add the total pounds of carrots needed based on the "amount" cells across all sheets.