How to reference code to another workbook

[fvisions]

The following is the start of a vba that I setup but I need to change it to a button on a different worksheet but have the code reference the Worksheet labeled "Exhibit A" for all the code process to work in. Any suggests / advice? I created a forms control button on a tab labeled "start here" for the end user to press.

Sub ExhibitA_Setup()
'
' ExhibitA_Setup Macro

   Cells.Select
Selection.Copy
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Application.CutCopyMode = False
Columns("A:E").Select
Selection.Delete Shift:=xlToLeft
Columns("C:Z").Select
Selection.Delete Shift:=xlToLeft
Columns("E:Q").Select
Selection.Delete Shift:=xlToLeft
    Columns("H:K").Select

 

[Norie]

The first thing you should do is create a reference to the worksheet you want the code to execute on.

Dim wsExhibitA As Worksheet

    Set wsExhibitA = Sheets("Exhibit A")

You would then use that reference in the rest of the code.

Sub ExhibitA_Setup()
'
' ExhibitA_Setup Macro

Dim wsExhibitA As Worksheet

    Set wsExhibitA = Sheets("Exhibit A")

    With wsExhibitA
        .Cells.Copy
        .Cells.PasteSpecial Paste:=xlPasteValues
        .Columns("A:E").Delete Shift:=xlToLeft
        .Columns("C:Z").Delete Shift:=xlToLeft
        .Columns("E:Q").Delete Shift:=xlToLeft
    End With
End Sub