Hi WaveOfMutilation
something along the lines of
Sub ProcessWorkbook(wbk As Workbook, rngDest As Range)
    Dim Letter As String
    Letter = Sheets(2).Range("A1")
    Select Case Letter
    Case "A"
        wbk.Sheets(2).Range("A1:A30").Copy
        rngDest.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
    Case "C"

    Case "M"

    Case Else

    End Select


End Sub