Combine 2 vba code make one output from data base

Dear experts

I have 2 kinds of excel sheets with macro vba, One macro get split data as new workbook from column A:A another workbook get split first 3workbook as new workbook..

i want make it these two MACRO code RUN continuously AS one code..so over all i want split data from column A:A with two sheet(PIVOT&CCI)

FIND THE ATTACHMENT

FIRST ACTION
SECOND ACTION

OUPUT

any experts can give efforts or lead?