search text in other workbooks

[jtaiariol]

Hi,

I wonder if someone can help me out. I have various excel files of book
listings. I would like to have a spreadsheet that can search column B in all
workbooks for a specific book title, then tell me which workbook the book
title is in and the row number if possible. Also can it find duplicate names
as well, thanks in advance for your help. I would then do the same for the
author.

John T.