Change Sheet tab from multiple Cell Values (Help FIX)

Hey Guys again i have a macro that changes worksheets (tabs) based on cell value. I have it working correct for one cell (B2) but i need 3 cells (B2, F2, M2) that i can type the sheet name in on the first sheet and it directs to the sheet could someone explain how i would add those cells to my code? Thanks for all the help.

MODULE:

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$B$2" Then
Call Go_To_Tab_0
End If
End Sub

Sheet Code:

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$B$2" Then
Call Go_To_Tab_0
End If
End Sub

Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Union(Range("B2"), Range("F2"), Range("M2"))) Is Nothing Then
Call Go_To_Tab_0
End If
End Sub

Thanks Guys they both worked perfectly.

Thanks Guys ill give these a try.

Hi again i just realized today that i still have an issue, I have 2 two cells i can type a sheet name into G10 and H10, But if i have sheet4 written in G10 and a type a new name into H10 it say sheet6 it will still go to sheet4 here is my code again for my Module and Sheet.

Module

Sub Go_To_Tab_0()
Dim strWsName As String
strWsName = Sheet1.Range("$G$10")
Sheets(strWsNme).Select
End Sub
l

Sheet

Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Union(Range("G10"), Range("H10"))) Is Nothing Then
Call Go_To_Tab_0
End If
End Sub

Thanks

Sheet1.Range("G10") and Sheets("Sheet1").Range("G10") are completely different and could be 2 entirely different sheets/ranges. Research sheet index number for some more clarification.

Okay here is an example i have two drop downs, One drop down contains sheets 1 through 5 and the second drop down contains sheets 6-10. Just think of it as the first drop down only shows Fruits and the second only shows Veggies. Ive been watching a few videos i knew nothing about macros till a week ago and just learning. I uploaded an example sheet, But thanks for the help

Workbook2.xls