If you need to create a Table of Contents for your workbook and update it periodically, this is a God-send!
I’ve just come across this link and not tried it out. But based on just reading the codes, this will either update an existing TOC or create one if you don’t have it yet.
There is a manual portion though, you need to be at your computer to manually close the print preview screens generated. The good side is that you decide how many pages each section/tab is, the downside, you can’t just run it and go off for a cup of coffee.