Filter based on tables, wildcards, and OR

I have an Excel workbook with 2 worksheets. The "Report" worksheet contains a table named "RecipientReport" that contains a report of users and their email addresses (the email addresses column contains multiple email addresses separated by ", ". The other worksheet contains multiple tables with lists of email domains labeled "Category1", "Category2", "Category3, and "Category4".

My goal is to create a separate worksheet for each category of email domains based on filtering the report by the domains. ie. the "Category1" worksheet should only contain users who have an email address with any of the "Category1" domains, etc.

I won't confuse this post with everything I have tried so far, but is there anyone who can help me accomplish this goal?


Thanks,

Dan

Not difficult as long as there is a file.

I appreciate the response, but what does that mean?

Here is the attachment