Table of contents for contents of 1 sheet

hi, Is it possible to create a table of contents for the contents of 1 sheet in excel. I have seen it done for multiple sheet names but I want it to do it for the contents of 1 sheet like a Word table of contents.

I have attached a sample file showing in "price listing" sheet how they layout might be.

if you look at the macros i found a macro for creating a table of contents from multiple sheets

why does excel not have a table of contents functionke work etc as any company that creates customer price lists/products lists or books needs to be able to give it to their customers. I have a minimum of 3500 active products at any divided into about 15 catagories with numerous amounts of subcatagories.


thanks