track changes when a merged cell text value = a specific word

[stalledprogress]

Hey Guys,

I've been reading other posts/Google Searching, but I just can't figure out the code.

Im trying to :
(this is not in VBA code)

If Cells I6/J6 (MergedCell)= "A Word*" (text with a wildcard)

Then Copy I4:J6 text values to Sheet 2
But put those cells in one row/seperate columns in the order of:
I4 | J4 | I5 | J5 | I6/J6 (MergedCell) | using a new row everytime a new entry is required.

e.g. If I change I6/J6 from "Goat" to "A Word" to "Bear" to "A Word 2", then this would record the 2 "A Word" entries in Sheet2 on different rows.

and repeat this process for K6/L6, M6/N6 etc.

I want to basically track the Sheet1 changes in Sheet2, when a merged cell text value = a specific word.

Many Thanks

 

[yogeshmaney]

Please provide data sample with results expected