Attached is a solution where the contents of each worksheet is pasted below the contents of the previous. Push the button and a separate master file will be created. After all content has been added, the master file is left open and you will to manually save it.
File removed, see correction below
Bookmarks