Hello there!
It is clear that you need duplicate rows detection tool, but it is not exactly clear how would you want it to work over multiple sheets. Basically the question is about the process: if you compare A to B and A is not equal to B, the outcome is clear. But if you compare A to B to C and you see that A=B but A!=C, you need a clear rule on which one will take precedence over the other. And if you are talking about more than 3 sheets it becomes more complex.
So we would need to chat about the clear requirements. Most of the things a technically possible, but no magic :)
Let me know if you wish to chat about the details.
Best regards,
Denis