How can I Hide Sheet 2 from a Cells Value from sheet 1?

I have three sheets sheet 1 is where user inputs info
sheets 2 and 3 are results
I need to only display one or the other sheet depending on the
value of a cell from sheet 1