Consolidation Macro to run with command button

  • Hey Folks...!!

    I have a VBA Script that will copy multiple file data from a folder to a Template that is pre loaded in the same file. My requirements is

    1. I want to add some command button and move the template to somewhere hidden. ( Its ok if a folder has to be maintained).

    2. At the end I dont want my macro file to close since I need to continue working with same Macro file.


    Please tell me a possible idea... My code is as below.