Ok, next question...

On the receipts sheet, say in cell D187, there is a line for the cash coming out of validator boxes. On the RoF sheets, there are 15 'blank' validator box areas, AP18:BH49...In there, AQ18, AU18, etc there are blank cells next to the box labeled NRT, so that when we pull boxes from them, and count them in, we can just put the NRT # it came from. Is there going to be an easy way to use D187 of receipts to look at the 15 blank cells to see if there is a box #1, and if so, pull from the total? The only other option I can think of, is to create a 4th page on the Rof sheets to make room for all 26 machines, and to specify each one individually, but feel like that will be a extra unnecessary work. Going to try to think of a way right now as well.

I basically need it to check 15 cells on 4 different sheets, though the cells to check are teh same on each sheet, and if it is what is needed, I want it to pull the total. Possible?