VBA copy paste using conditional statement from one workbook to another and also to specific month column

I've to copy data from source file and paste it to destination. The range of source file data(i.e. row) keeps on changing. Also, I've to paste data in specific month columns avoiding empty weeks columns in between them.

Windows("CARE Ops Playbook_WE_September-08-2018.xlsm").Activate
Windows("2018 Weekly Review.xlsx").Activate
Range("AS23").Select
Sheets("Care-Weekly").Select
ActiveSheet.Range("$A$1:$Z$70").AutoFilter Field:=1, Criteria1:= _
    "Care_Service_VQ"
Range("Z59").Select
Application.CutCopyMode = False
Selection.Copy
Windows("CARE Ops Playbook_WE_September-08-2018.xlsm").Activate
Sheets("SL_Efficiency SVC").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
    :=False, Transpose:=False