I have about 148 files in an Excel directory. Is there an easy way to search
the first four rows of all these files and find the word 'title'. If that
word exists, I would then like to copy the word that is next (the cell to the
right) to that word and paste it in a new file. If the word 'title' is in
cell K4, the actual title will be in L4.

I would then like to copy the contents of the title and the name of the file
(or its path) to a new file called, say, Lists.xls.

Not all files in the directory will contain the word title. All the files
currently reside in C:\UFBooks

If this can be done it would be a huge time saver. Thanks for you help.