I have just been informed that 2010 has enhanced capability to reference CF across sheets (thanks Jeff)