I have Invoice template sheet, my sheet name is EST01, EST02, EST03 and myself I doing move or copy sheet such Invoice number continuation with "EST" letters manually. So my requirement is 1. copy sheet and change sheet name such Invoice number continuation automatically. 2. That sheet name Invoice number will be update to target cell range is "J6". 3. The EST with "zero" require up to EST09, after that the Invoice number I want like EST10, EST11, EST12 continuation. Please help with suitable VBA code.
Very much thanks and regards,