Creating a list of contents for 25 isses of the one magazine

I have 25 issues of a magazine I edit. Each is between 45 pages and 60 pages long. Each has a contents page. I want a list made of each article, the issue number or date and the name of the author. I want this done in a table in Excel or Word with three columns. If this project is successful I may then ask for an index to be made of the contents but I fear that would be too expensive.