Hello. I have a series of templates that I'm working with. Each template will contain at least 1 worksheet for the current month of data. I need to copy the previous month's worksheet and the name will be in format "MMM YY". I can't always retrieve the last sheet as there may be a supporting worksheet from the previous month that will occupy the last sheet in the workbook so this is why I need to find the previous month using that format. Also there is a 1 month lag so if I'm working this process in the calendar month of April, I will need to find the sheet named "Feb 10", etc. Is there anyway I can code this using vba? Any help will be much appreciated!!