Automated Excel Sheet Backup

I need a small, reliable routine that will back up specific sheets from my main workbook at the click of a button (or another simple trigger) without breaking anything that is already there. The backup must carry over everything on those sheets—formulas, data-validation rules, existing macros, the lot—so the copy can be opened later and behave exactly like the source.

My workbook is already full of formulas, some validation, and a few VBA procedures, so the code you write should respect what is in place and avoid naming collisions. Ideally, the solution sits inside the file as a VBA module, asks me which sheets to copy (or lets me store a default list), then saves the duplicates to a time-stamped file in a folder I specify.

Deliverable: a fully commented VBA script (or lightweight add-in) dropped straight into my workbook, plus a brief note explaining how to change the target folder or sheet list if I ever need to. I’ll test by running the routine and comparing the backup with the live sheets; everything must calculate the same and all validations and macros must remain intact.