Identify rows matching certain criteria

K, here's my problem.

I have a worksheet with a list of cells containing text of 4 characters each
Example
4H5B
SDP1
SDK2

Additionally, I have spreadsheet where these may or may not be contained.

If they do appear on the worksheet, I need to identify them by either highlighting the row or looking up the row or....

The catch is that the cells being referenced (4H5B etc) above appear in the worksheet in a string of text.
E.g.
4H5B APPLICATION ACCOUNT*
QS4H5B

Hence if the cells being referenced appear in any way on the worksheet, I need to identify that particular row somehow!

Am I asking for a miracle?