Excel - Dynamic Table of Contents

Diceicle

I presume this is possible but info I've been able to see online so far is not hitting the mark.

I would like to create an excel Table of Contents (TOC) for a workbook.
The TOC should function like a Word TOC insofar as it should update page numbers 'itself' when a worksheet is a greater number of pages etc.

For sake of example if you imagine an end of year expenditure report for a large company with differing depts each on a separate tab:-

• Logistics
• Procurement
• Sales
• Marketing
• Finance

They need to combine into 1 PDF with a TOC.

namenotavailablE

Does the attached do what you're looking for?

Box file: https://app.box.com/s/mtmqi7gu987be76ury4ff45urav8wojg

As you add sheets to the workbook, the TOC will update when you click on it [you MUST click on the TOC sheet to update the table of contents; also, I've assumed that the TOC sheet is the 'leftmost' sheet in the module code i.e. all the other sheets are to the right of the TOC sheet]

EDIT: I fixed a bug @ 11am 1 Feb in case anyone downloaded an earlier version