While you could tediously copy and paste names and addresses from a text document, with a little know-how in Excel, you can make the process far easier.

How to create an automated list of worksheet names in Excel -- and add a table of contents.