Finding duplicates across multiple sheets, in all sheets

[seriousallthetime]

I have a list of products. It is divided into 12 months. I know for a fact some products appear in more than one month. I want to find the values that appear in all 12 months. How do I do that?

I understand how to find duplicate values across multiple sheets, but I don't know how to find only the duplicates that appear in all sheets. Some sort of pivot table?

 

[DanteAmor]

Check the macro in the following link

https://www.mrexcel.com/forum/excel...ing-duplicate-data-multisheet-workbook-3.html