Compare lists in Multiple workbooks
 

I have two workbooks, each with information that looks like the following:

Column A -- RECORDS CENTER/WAREHOUSE/003/SECTION 06/CLKCA
00000/ 1900CA000001 (The number 1900CA000001 is a file number and is what I
need to compare)
Column B -- 1
Column C -- Doe, John

The first Column is a location and a file number. (The file number is the
only thing that I am concerned with)
The second Column is a volume number, so the file number might repeat itself
if it has more than one volume.
The third Column is a description.

The rows can vary from 10 to thirty or more, with 40 or more worksheets in a
workbook. The information is extracted from another program, thus the look
and format.

I have two seperate workbooks with this information and I need to compare
the two, and list in a seperate workbook (Or at least a worksheet) any files
that duplicate on the two lists / workbooks. Then I need to be able to sort
the results so that they are all together. It would also be nice if the
duplicates could be highlighted so that they stand out. I've asked about
putting this in something other than Excel, but the powers that be say that
it must be in Excel. One list is a list of files that are to be deestoryed
and the other is a list that we need to keep.

Thanks for any help

~Tim