Pruning Unwanted Date From A Cell

I work in laboratory that out puts a spreadsheet in to excel.

The sheet is of variable length and the data i am interested in is imported in 1 column the data consists of test names(separated by commas) that we have done, my problem in need to extract only certain tests.

i would like to define the required tests on another sheet and then remove the ones not in the reference table

1 SVPCR,BAL,PCP,VPCR

2 GMPCR

3 SVPCR,PUOM,VPCR

4 RATH,SVPCR,VPCR

5 RVPCR

so

row1 only want vpcr
row3 only want vpcr

i have tried substituting the unwanted for "" but the list is ever expanding and thought that a little reverse logic would work even tried text to columns but because the desireables are in different columns this makes life very hard