cut & paste the data

[MoldyBread]

Hi Experts,

I am looking for a macro that will do the things mentioned below
macro will be placed in macro.xlsm,both files are loacted in diffrent places so the path will be hardcoded in the macro so that i can change it as per my needs
sheet name can be anything
Plz see the sample file & the output file

If column I of 1.xls matches with sheet2 of column B of book2.xlsx then cut that entire row & paste it to new sheet in 1.xls
If column D of 1.xls equal to column E of 1.xls or column D of 1.xls equal to column F of 1.xls then cut that row & paste it to new sheet in 1.xls
& header will be same in all the sheets & the old sheet will be delted ( both will be done by macro only)

Thnx For the Help