Excel VBA script to populate another sheet conditionally

I would like to write a VBA macro for excel through which i want data from a master sheet to populated to another sheets conditionally.

for example, my master sheet ("Sheet1) has multiple rows and column. The condition for data population from Sheet1 to Sheet2 should be based on these condition

(1) Only rows which has a particular string in a column (say "keyword" string in column D)

(2) Only few columns to be copied from Sheet1 to Sheet2 (say column A,B,E & G)