http://www.excelcampus.com/tips/automate-excel-tasks/
This video explains how you can use the Tab Control add-in to automate common Excel worksheet tasks. This includes processes like:

- Adding and naming multiple sheets to your workbook.
- Hiding and unhiding multiple sheets for a monthly reporting package.

The Tab Control add-in can save you a ton of time with repetitive worksheet tasks like hiding & unhiding, ordering, sorting, naming, and coloring sheets.