transfer data from a database(excel.xlsm) to an old worksheet and creat it with new name

Hi all,
I already transfer my data from database (excel.xlsm) to an old worksheet (excel.xlsx) with a table by using VBA. Now I want to make this old worksheet become a new file with new file name like yyyy/mm/dd/where. Is that possible? Thanks a lot.

Thank you for reply.
I mean I want that old worksheet become another new worksheet with specific name when I use VBA to fill it out before I save it by myself.

Thanks a lot!