Counting occurrences without named sheets

I have a workbook that will have one static sheet and then sheets will get added and subtracted as times goes on; currently there are 3 of these.

I'm trying to have it count the number of times it finds A2 across all sheets, range B14-D14.

Currently, I have:
=SUMPRODUCT(COUNTIF(INDIRECT("'"&sheets&"'!"B14:D14),A2))

This doesn't work well, as I will have to keep manually adding and subtracting names to a sheet range.

Is there a way it can just scan all sheets in the workbook (minus the one it is on) for B14-D14?

i'd do it with helper cells and consolidation

I made a sheet "l" and "r" and put them on both ends of the range of sheets.

I tried

=SUM('l:r'!B14)

It gave #NAME.

B14 has number values in them.

Is there not an easy way it can scan a specific cell across all sheets and sum it?