Referencing multiple lists into one master list

Hello, 

I have about 8 different contact lists (total of 25k contacts) and I am trying to combine them all and see which contacts appear on multiple lists.

For example, I am trying to get my master list to appear something like this: 

John Doe  john.doe@email.com    List2  List4 List5 

Mary Apple apple@email.com      List1  List3 List 7 List8

and so forth. 

Thank you for any help.