Search for a value in a column and copy row to new sheet for all matching values

Greetings All,

I have been working on a macro that allows me to search for a value in a column and copy the row with matching values to a new sheet.
The following web link has greatly assisted me with running a macro - http://www.techonthenet.com/excel/ma...for_string.php

Unfortunately, the raw data i have present doesn't allow the macro to fully function and i need some guidance with resolving this issue.

The current macro only identifies and copies cells with a single value. However my raw data has several options codes within a cell.

Dd.jpg
Is it possible to modify the following formula to identify a specific value within a range of values? If Range("D" & CStr(LSearchRow)).Value = Range("C1") Then

If else should i split the options to separate cells? If that's the case how do i expend the current range from "D" to "D","E","F"?

Truly appreciate your assistance!

Thank you in advance,
Gopi