I have a folder with multiple files with files name such as "2014-14346 XX XXXXX.xlsx" with the next one being "2014-14347 XX XXXXX.xlsx"
I was like a save as button look up the most recent file name, increment it and save the current sheet as that file name. Also it would need to pull some addition data from cells in the sheet, that is what the XX's are.
At the very end I would like it to close the current template and open the recently saved one.

Your help is greatly appreciated!

Sean