Finding Dupes in column array in excel

Hello, I have been tasked with takin the data  provided (just a small sample) to identify if the plans have all the same elements configured the same.  

I have Attached the example and basically need to Identify Each of the Plan Marketing Names that have the same plan configuration (Rows 9 through 152) into a new worksheet that shows the duplicated plans together and the unique one separately.

PROBLEM 1 - need the Check columns I started for the first 3 to be a function for the entire data set in each tab which is 77 Columns long.    
PROBLEM 2 - need to do this function across several tabs

PROBLEM 3 - need to do this function across several different documents