Pulling and sorting data from one worksheet column to another worksheet based on keywords

Hello,

I have two worksheets in a file, Sheet1 and Sheet2. I am trying to pull various data from ColumnD (accompanied by the data in ColumnI) in Sheet1 into ColumnC and ColumnD in Sheet2, based on key words in an individual cell in ColumnD. ColumnA in Sheet2 would list out the different key words pulled.

The data in the worksheets are entire phrases. I plan on sticking a type of 'run-when-workbook-opens' script at the end so Sheet2 is filled out by the time the user looks at it.

Any suggestions would be helpful. Thank you!

- Jean

Edit: I removed the example because I couldn't preserve the formatting. But please let me know if attaching an xls example would be of benefit.