Wow, that should have actually worked well, all of the pricing pages have a
value in the same cell that changes as they are bidding different material
types, however, after I set the cell to AI8 (each page totals in AI8) I ran
the macro and got my master pricing sheet of 10 pgs and two other sheets with
no value in AI8.

I changed A1 to AI8 and < "" to < "0"