CF cannot cross from one worksheet to another
On the worksheet where the CF is needed find a blank, out of the way cell,
and use =Worksheet2!B6
In the CF setting, reference the cell with this formula
Experiment and see if the column or row with the formula can be hidden - I
cannot recall
best wishes