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

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

I acknowledge your effort, but next time, please use [code]your code[/code], not quote tags.

You haven't said which line is causing the error, so all we can say is that a sheet name, workbook name or window caption is incorrect in your code.

Either one of those sheet names is wrong, or the Schedule template file name is wrong, or you don't have two sheets in your template file.
Where is the code located? (specifically, which code module in which workbook?)