Identifying and merging matching ID's within range automatically

[aabbey]

Hi.

I recently discovered =TEXTSPLIT which has been really useful for extracting Activity ID's and their relationships in the scheduling software I use.
Now I need to filter out the irrelevant relationships and return that information into a usable format.

You can see a component of this in the attachment.

My goal is to filter out the noise from Columns C-P and only return ID's that are also Activity ID's In Column B

Sheet Info

C-P have alternating purposes
Column C Pre1 has the predecessor Activity ID to what appears in Column B
Column D PreR1 contains its respective relationship, and so on.

I would like to transfer the relevant data automatically to the table below and merge the Activity ID and relationship.
I understand the merging part may require a helper column and that bit is easy enough
Returning info that matches ColB within the range Columns C-P is escaping me though.

Any assistance will be happily received.

In the attachment you will see the end goal.