multiple page if statement

[DBsWifeLB]

Is it possible to say something like:

"If column b has a 1510 then add column g"

Then include the same question to each of the tabs of the worksheet?

I am trying to consolidate information from 10 pages to 1 but much of
the information is different, meaning the 1510 is not in all sheets but
does need to be included into the consolidation.

Maybe if someone knows a better way you can help?

Thanks!
Completely frusterated!