Need a Macro to do Daily task

[krishhi]

Hi there,

I have a some small problem. Please look in to my query and if possible please show me a solution.

Here is a excel sample that i attached.

It contains data relates to Some cources, it has been collection every week in a month.

Here what i need to Filter the Excel with string "Main" on Column "E" then Copy the data in to Output sheet, as shown in the excel file. Then Go to "Master" Sheet then Filter on Column "E" with the strigns "Secondary and Third" then Filter on Column "F" with String "Main" then copy the data and paste it into Output Sheet as shown in the Excel. and For G Column viceversa.

I know we can do manually, but I need this to do every day to prinout the data and I have 100's of similar tasks. So, I need a macro to this task.

I try to figured it out but my thumbs down,.

Can any one help me on this?

Waiting for your kind reply.