I see others needing comparison betweens rows or columns. I also see compare of 2 sheets or files.
Not sure which would work for what I want/need.

I have sheet1/file1 that I need to compare to sheet2/file2, 3, 4 and etc.
I was thinking if data from file1/sheet1 doesn't have a match with any than I would get a msgbox.

So is there a function for comparison or just use macro?
I have example I would like to have added. Example is only has 5 data. I want something that would be less coding as if I have 100 data.
comparison.xlsx