Can someone help me to write code that will take a worksheet in an existing file and move it to a new book and save the new book in a specific location with the same document title except that the month identifier updates every month. For example. I have a file with a work sheet for 5 different stores and I want the code to move each sheet into a new workbook and save it as the file name "Westover - [Current Month]. The code that I've tried from the research that I've done doesn't work at all. Any help will be appreciated.

Cheers,

Chuck