How do you reference a cells info to be counted as a cell?

[Harry0]

Sheet one does not do as it is told to.


Also see page 2 which tried to reference a worksheet based on the text.
Obviously I can just put a bunch of If's and reference it in another way but how can you do it without the if's?

Thanks

 

[Luke M]

I think you're trying to build a reference using contents from cells. In which case, you'll be wanting the INDIRECT function:
http://forum.chandoo.org/threads/what-is-indirect-function-solved.10688/

Do note Jeff's warning about volatility...don't want to go overboard with this.