Combine Multiple Macros

Run the code for copying Sheet2 first, do the copy and paste special on the worksheet in the newly created workbook, save the new workbook and add code to close it.

Then run the code to save the original workbook.