Help Counting Same cell across multiples sheets with specific sheet name

You could create a list of the sheet names using this technique:

https://www.excelforum.com/showthread.php?t=929969

Then, you could use a formula to see if the 404 is in the sheet name then return the value from B2 of that sheet.

Then just sum the range of those formulas.