This macro on David McRitchie's site uses the sheet names, rather than
the headers, but it should be relatively easy to adapt. Post back if you
need assistance:

http://www.mvps.org/dmcritchie/excel/buildtoc.htm



In article ,
"robin" wrote:

Is it possible to create a table of contents in excel using the headers of
sheets?