I have a workbook with multiple worksheets and I want get data from each worksheet total it and place the result into another worksheet within that workbook.

Each sheet is an individual product, listed on each sheet is the ingredients that make up the product. Column headings Autumn, Winter, Spring, Summer and row heading for each ingredient used. For example Pleurisy Root (herb) is used in a number of different products and I want to add up all the Pleurisy Root used in Autumn, and put the result in a master sheet that displays the total amount of Pleurisy Root used in Autumn.

As I have limited experience with Excel I had been using the following formula



'Sheet_1'!E29+'Sheet_2'!E29+'Sheet_3'!E29

In the workbook there are 98 product sheets and Pleurisy Root is used in 45 of the products so the above formula ends up being incredibly long, time consuming to create and prone to mistakes. Is there a solution that will lookup the Pleurisy Root used in Autumn on each sheet, total it and place the result in the master ingredient sheet.

Hope this is enough info and is understandable, thanking you in advance for your help.

Safrac