Need help with vba macro in the below scenario 

I have data in one workbook in sheet 1(raw data)

I have to apply filter to the sheet and filter by pending from status column.

Need to copy entire data except the header and paste in another existing workbook_2 in sheet 1,(report). Remove the filter.

Now again filter the data by completed status along with T-2 Working days from end date column.(Raw data). 

Copy entire data, except the header and paste in (report) below the existing data.

Remove both the filters.

Again filter the data by exception in status column & copy entire data except the header and paste in report below the existing data.

Now from report sheet of workbook_2, have to copy column F,G,H,J and have to paste it in sheet 1 of Workbook_3 in column B only starting from row 4.

​Need help with vba macro in the below scenario  I have data in one workbook in sheet 1(raw data) I have to apply filter to the sheet and filter by pending from status column.Need to copy entire data except the header and paste in another existing workbook_2 in sheet 1,(report). Remove the filter.Now again filter the data by completed status along with T-2 Working days from end date column.(Raw data). Copy entire data, except the header and paste in (report) below the existing data.Remove both the filters.Again filter the data by exception in status column & copy entire data except the header and paste in report below the existing data. Now from report sheet of workbook_2, have to copy column F,G,H,J and have to paste it in sheet 1 of Workbook_3 in column B only starting from row 4.  Read More

​