MSexcel creating index linking subjects to page nubers in footer
 

Using MS Excel 2003 I would like to create an index with subjects and page
numbers for the pages on which specific subject are from the page number in
the footer. Is there a way to do that easily?
ps. If anyone knows how to do it in 2007 I have access to that at home.