Hi!

The quickest way would be to sort the sheets!

If you can't do that:

Temporarily rename your sheets to 1, 2, 3, 4 etc.

Assume the names are in the range A1:A87

Enter this formula in B1 and copy across to 12 cells then down 87 rows:

=MATCH($A1,INDIRECT(COLUMNS($A:A)&"!A1:A87"),0)

This will show you where each name is in each sheet. If all the numbers are
the same in all 12 columns across that means that name is in the same place
on each sheet.

Biff

"Ali" wrote in message
...
Hi, I have approx 12 sheets. On each Column A is a list of 87 names.
Some
changes have been made to later lists but I need to correct all lists to
eb
the same. How do I ensure that the SAME name appears on the SAME line
across
all sheets as the final sheet reads totals from a formula. Checking each
list manually is taking too long. Thanks