Help Searching Mutiple Job#

I want to be able to insert in my table the information: PO,Project Description,Customer,Payment Teams,Business Unit,Submitter,Notes from anothe sheet that contains the Job information. From the Job# column, I've done it before with an index match but only when is one project.

I want to be able to do it for multiple Job Number that are in the Job # column separeted by a " - "

In this example will be Job 123, Job 124 and Job 125.

Is there any way to do this?