Thanks in advanced for time:

I am going to be adding a list of option numbers with their description per
order to worksheets. The worksheets will be named sequentialy as Sheet1
Sheet2 etc.

The option number will be in column A and option description (useless so
far) will be in column b

Every time I add a worksheet, I want to be able to compare this worksheet
with all of the worksheets stored comparing common and uncommon option
between them.


When the comparison macro stops running comparing all of the available
worksheets, I should be able to see a percentage of matches (same value
options) per worksheet that exist in a message box. Like:

Sheet1 90% Match
Sheet2 95% Match
Etc.

Thanks again!