Linking sheets

[Bob Taylor]

How can I have information, if it meets a criteria
automatically link to another worksheet. Even if people
aren't sure, could you point me in the right direction?
Maybe IF functions?

 

[Don Guillett]

with a formula
=if(a1=5,sheet1!a1,"")