Do you have a workbook or existing code to share?
In any case, add this code to a module in the workbook, and then assign the macro to a button you insert on the sheet. Please note that cells B1 and B2 on "Sheet2" are where the code gets the file name parts from, but you can easily change the code to suit. I made the file extension xlsm instead of xls because that is a macro-enabled workbook which you need if you want a macro in it. Hope it helps
p.s. this code will give you an error if the folder does not exist, you can probably find code to make the folder if needed, but I wasn't sure how you want to handle that, and assume you will create the folder to save backups in.