Compare 3 lists of data against a master list

Hey all, I'm stumped.
I'm trying to compare lists of email addresses to see who opened what. We have 3 different lists of 'opens'- those who open Summer Newsletters(Column H), Fall Newsletters (Column I) and Winter Newsletters (Column J).

I need to compare them against all of our contacts (Column A) to see who out of column A (all contacts) opened what newsletter (H, I, J or any combination of the three.)

I also need to know which ones were opened by who- i.e.- 'John' is a contact in column A. John opened 'H' newsletter, didn't open 'I' newsletter but did open 'J' newsletter. I need a formula to show John opened H and J.

Thanks in advance, any help is WAY appreciated.

Upload example workbook.

Make sure to remove private data (like names or e-mails) but keep formatting (i.e. [email protected])

I'm not sure how to upload. Sorry, I'm a rookie at this.

Example.xlsx

For this example, I need to know that 'mama' opened Summer and Winter, 'brother' opened Summer and Fall, etc.

Thanks a million.

^I'm sorry, I meant 'brother' opened all three, 'sista' opened Winter only.
Long day.

maybe so. see attachment