You can specify whether you want the replicated worksheets placed into multiple workbooks, one workbook with multiple worksheets, or printer output.
Copying Formats into Multiple Worksheets
Creating a Table of Contents for Multiple Worksheets
Specifying Multiple Worksheet Names
Specifying the Destination Directory of Multiple Worksheets