I have a simple question (perhaps).

I have 12 seperate workbooks with lists of names, contact info, etc. Many
of the names appear in more than one worksheet. The names are all entered in
separate fields within the worksheets. I would like to do an analysis of the
data showing which names appear most often , least often - etc. Is there a
simple (relatively) way to do this with excel? Or any other app - ?

may thanks for any advice.
--
Peter Syvertsen