I have a workbook with numerous worksheets. Some of these worksheets are named in running order such as INF001, INF002, INF003.... and so on. I need to create a new workbook for each of these worksheet based on the name of these worksheets. I need to include several macros in each of these workbooks that get distributed to the person in charge. How can I copy the modules from the original workbook to each new workbook