Entire workbook formula help

[nwtaco]

Hi I am trying to get a total sum for the keyword "loss" governed in the formula below across multiple spreadsheets, and this isnt working for me. The keyword is located on all spreadsheets in column F and the amounts are in column D, and i want to know the total amount. There are 90+ spreadsheets in the workbook and are in consecutive order via store name and month (see attached pic)

=-SUMPRODUCT((ISNUMBER(SEARCH({"*loss*"},'Argonne January 2017:Wandermere September 2017'!$F$2:$F$250)))*'Argonne September 2017:Wandermere September 2017'!$D$2:$D$250)Thanks!