Lookup the datas from all sheets and make summary on a separate sheet

I have a file with so many sheets.I want the grand total on a particular sheets of each parts from lookup the datas from all sheets.

Please refer the attach file for more clarification.

Regards

Hi

In summary Sheet, make a List of your Sheets and give a Name to it. Name this as List.

Then in D4, use this formula.

=SUMPRODUCT(SUMIF(INDIRECT("'"&List&"'!b4:b1000");B4;INDIRECT("'"&List&"'!d4:d1000 ")))