Thats all the macro does is open files copy data from them and paste them into template. I am not sure how you are missing that part.

I see you shortened the code, nice job. I didn't know the code language well enough to write it that way but i see now how each item works and what it does. The only problem I see so far is that 

Set wbDaily = Workbooks.Open(Filename:=strPath & "DATE1-DATE6_CIC_DailyFile.xls")
and
Set wbDaily = Workbooks.Open(Filename:=strPath & "DATE1-DATE6_GA_DailyFile.xls")
Still have the DATE1 and DATE6 in the file name which is the part I want to replace with each week's weekdays dates. Otherwise its shorter and looks awesome so far.