excel 2007: run-time error '9': subscript out of range

Hi, am having issues importing worksheets from another workbook. Can anyone help, please?

Sub Golf()
'
' Golf Macro
'
' Keyboard Shortcut: Ctrl+Shift+O
'
    ChDir "W:\Schedules"
    Workbooks.Open Filename:= _
        "W:\Schedules\Order Hole-in-One.xltx", _
        UpdateLinks:=0, Editable:=True
    Sheets(Array("PlacementConfirmation", "Invoice", "Certificate", "WitnessChecklist" _
        , "ClaimForm", "Affidavit", "Terms", "BrokerList")).Select
    Sheets("PlacementConfirmation").Activate
    Sheets(Array("PlacementConfirmation", "Invoice", "Certificate", "WitnessChecklist" _
        , "ClaimForm", "Affidavit", "Terms", "BrokerList")).Copy Before:=Workbooks( _
        "Schedule Hole-in-One.xltm").Sheets(2)
    Windows("Order Hole-in-One.xltx").Activate
    ActiveWindow.Close
End Sub