I have an Excel workbok , that contains lots of sheets. Each have the same
structure.
Ex. data1 to datai and i is up to 100

Is it possible to write a formula like that ?

If datai'!A1=150 sum datai'B1

Sum all B1's of all sheets that has datai'!A1=150 condition.