The problem is probably that the wrong sheets are being referenced.