Validation Lists and Macros

I have a macro that runs when I click on three different validation lists (code below). I now have another validation list (at G9) that I need to run 5 seperate macros depending on the validation list selection...how can I add to the below code so this functions properly? Thx


Private Sub Worksheet_Change(ByVal Target As Range)

'Do nothing if more than one cell is changed or content deleted
If Target.Cells.Count > 1 Then Exit Sub

If Not Intersect(Target, Range("G3,G5,G7")) Is Nothing Then
Call RefreshPandL
End If

End Sub



Any Thoughts?