Excel help

Need some excel help. Need to exclude a specific column from a range when copying from one sheet to another. Here's what I have:

Private Sub Worksheet_Change(ByVal Target As Range)
  If Target.Address = "$G$1" Then
    Range("A2:P570").Value = Sheets(Target.Value).Range("A2:P570").Value
  End If
End Sub

Need to figure out how to leave out the entirety of column K.

Thanks in advance

>>10 need not reply.