Macros

I have a macro that currently saves a file with the information that I have told it to but I need to take it a step further and I would like the macro to also find a certain piece of information such as a title and drop it into the file name when it saves.  How can I go about doing this.  The document I am working off of currently has 54 records merged with it out of excel and will cycle to the next record to create the saved document.