I need a macro to copy...call it Module 1...from an open workbook named "MRO Induction Form (Blank)" to another workbook. "MRO Induction Form (Blank)" contains a page named "Induction Form" which I rename to "Induction Form (2) and then move that page to create a second work book. Unfortunately, the macro does not move with it. At this point in the process, the second workbook has yet to be named.

Another way to approach this is to copy "Module 1" when I "move" Induction Form (2).

Any help will be appreciated