Using macro to auto save as with todays date

Hi, i hope i am posting this in the right place.

I am making a production plan system using excel. I have a button with an assigned macro, which basically sorts two worksheets of data, prints them both then unsorts. The data that is printed is then used by my production team for their daily work. What i am trying to do is add some code that saves a copy of the sorted data, with todays date within the same button click. The data is new everyday and at the moment my production area is littered with these printouts and i would much rather an electronic copy saved. The saved copy would need to be a 'saveas' version as to not alter the live workbook. I also only want the save command to save two specific worksheets and not the whole workbook.

I hope there is someone out there who can point me in some kind of direction.

Thanks in advance

Steve.

Thank you for your reply, will that code work with office 365?