a list of title block information in an excel file

Hi,

I've done this in the past but I can't remember how I did it. I'm sure there is a better way now. 

What we need is to be able to grab the title block information from our drawings and have that information listed in an Excel file or a Word document. 

I remember placing a .bat in the same folder as the drawings and then choosing the run macro button (or something like that) in one open file. This would create a list of all the drawings in that folder.

In other words. My engineer wants a list of the names of the drawings in an excel file. (Not the file names. But the names of each drawing. As an example: 

230/69KV Control Room
Switchgear
PSC Panel  

They are a combination of data fields and simple text. Drawings from last century and this century.  

Thanks for any and all suggestions.