I might have missed it because with all the Activating/Selecting it's hard to see what's going on.

As far as I can see, apart from the first two workbooks, you are manipulating the workbooks you are opening as well as copying.

For example, this opens a workbook, does a bunch of formatting in that workbook, copies from it and then moves onto the next workbook.
Workbooks.Open Filename:= _
        "I:\ACCOUNTING\Clear Payments\2013\2013-01\Completed\DATE1_CIC_LocationSummaryReport.xls"
    Columns("A:A").Select
    Selection.NumberFormat = "mm/dd/yy;@"
    Selection.ColumnWidth = 10
    Range("A6").Select
    ActiveCell.FormulaR1C1 = "date"
    Range("A7").Select
    ActiveCell.FormulaR1C1 = "DATE11"
    Range("A7").Select
    Selection.Copy
    ActiveCell.Offset(0, 4).Select
    Selection.End(xlDown).Select
    ActiveCell.Offset(0, -3).Select
    ActiveSheet.Paste
    Application.CutCopyMode = False
    Selection.Copy
    Range(Selection, Selection.End(xlUp)).Select
    ActiveSheet.Paste
    Application.CutCopyMode = False
    Range("A7:N7").Select
    Range(Selection, Selection.End(xlDown)).Select
    Selection.Copy
    Windows("zIntegration template BLANK.xls").Activate
    ActiveSheet.Paste
    Selection.End(xlDown).Select
    ActiveCell.Offset(1, 0).Select
As for DATE1 and DATE6, you could use constants or variables for them just as you are the path.