Comparing Across Sheets

[RJB]

Have files with 52 tabs of sheets each.

21 columns across, each with a VLOOKUP to the bottom of the sheet.

On each sheet, the VLOOKUP table looks kinda like this:

0 - Scenario 0
1 - Scenario 1
2 - Scenario 2 etc.

HOWEVER, at some point over the course of time, you will have, on say, Tab 14,

0 - Scenario 0
1 - Scenario 1
2 - Scenario Springsteen

and on, say, Tab 36, you could have
0 - Scenario 0
1 - Scenario 1
2 - Scenario Quesadilla

Is there a quick and dirty way to compare all 52 sheets and see where there
are changes in a particular cell?

(2 - Scenario Xxx will always be in same cell position, regardless of sheet)

 

[Herbert Seidenberg]

Here is an example with 14 sheets:
http://www.freefilehosting.net/download/3d5eb