I have a workbook where i create "daily reports". I'm trying to find a VBA solution to "copy" the most current report, and create a new tabsheet. (the same way you would right click on the tabe, and select "create a copy". I've tried recording a macro to do this, but the macro keeps trying to copy the same report, and since i have VBA that changes the sheet name automatcially by one numberal, it won't work. Can someone help me with the code so that i can copy and create new sheet tabs based off of the active sheet? Many Thanks for any help on this!!