Simple Excel Macro

A) THIS SPREADSHEET, [login to view URL], WILL BE THE MASTER SPREADSHEET B) IT HAS 1 TAB (PRODUCTION) C) IT WILL BE STORED ON A NETWORK D) WHEN SOMEONE GOES IN TO MAKE AN UPDATE, I WANT THE MACRO TO DO THE FOLLOWING: 1) SAVE THIS ORIGINAL MASTER FILE ON THE NETWORK (I'LL UPDATE THE ACTUAL PATH, BUT I'LL NEED YOU TO SIMPLY WRITE C:\PATH\ IN YOUR MACRO, OR SOMETHING SIMILAR) 2) COPY THE PARTICULAR SHEET THE END-USER IS CURRENTLY EDITING TO A NEW SHEET 3) MOVE THE CURSOR TO CELL B68 4) COPY THE TEXT IN CELL B68 TO THE CLIPBOARD 5) SAVE THE NEW FILE AS "PASTE THE TEXT FROM THE CLIPBOARD AS THE FILE NAME" 6) SAVE THE NEW FILE 7) EMAIL THE FILE AS A PDF TO THE EMAIL IN CELL F56 (I PRESUME THROUGH THE FILE MENU AND SHARE, EXPORT AS PDF, BUT MY MACRO KEEPS FAILING WITH THE TEMP PATH…???) 8) ALLOW THE END-USER TO TYPE ANY TEXT IN THE EMAIL THEY WANT TO 9) THE END-USER WILL PUSH SEND ON THE EMAIL 10) THE END-USER WILL THEN BE RETURNED TO EXCEL 11) **IF THIS IS NOT TOO HARD TO PROGRAM, YOU CAN ADD IT** -- A POP UP MESSAGE BOX THAT SAYS "YOUR EMAIL AND REQUEST FOR APPROVAL HAS BEEN SENT" WITH AN OK BUTTON 12) MOVE CURSOR TO CELL A4 13) SAVE FILE IN SAME DIRECTORY 14) CLOSE FILE