Just like the title says, let's just go a little more detailed.
If A1 ever equals "1", I want Sheet 2 to automatically be displayed.