Extract 1st,2nd occurrence of keywords in string, from named ranges, into separate columns

I have a column of data (MyData) from which I need to extract multiple keywords/phrases from each row. Please see attached example.

The keywords/phrases from MyDefinedListA may/may not exist in the string, but will only appear once if it does.
The keywords/phrases from MyDefinedListB & MyDefinedListC - may/may not exist in the string, and could appear more than once.

I'm trying to extract the Nth occurrence in a separate column for each word in the MyDefinedListB & MyDefinedListC - there should be no more than 4 occurrences in total.

The attached example is how I would like the result to look (I have limited it to 2 occurrences in this example but it can range up to 4 in either of the MyDefinedListB & MyDefinedListC named ranges):

I have tried to work this out but am having very little success.

Any help would be really appreciated!