I'd like a "If a certain cell matches this number, go to Sheet 2"

Macro required. You would put this code in whatever sheet it is that has the A1 you are talking about.

Private Sub Worksheet_Change(ByVal Target As Range)

   If [A1] = 1 Then
      Sheet2.Activate
   End If

End Sub

This assumes that there is some value on the same sheet that will cause A1 to become 1. If A1 has a formula that refers only to other sheets, then this won't work.