Please, review topics below to find answer to your question

Compare | Sheets menu command

Use this command to compare 2 worksheets.

This command is similar to Compare | Books command. But it compares 2 worksheets, which are selected in the xlCompare left and right panes.

Use this command when you want to compare worksheets with different names, or when you are comparing sheets in the same book.

xlCompare compares all worksheets with same names in the opened books. After comparison you get Difference Browser window. It displays comparison results.

Difference Browser