I wish that the developers at Autodesk will consider having the option to renumber the new drawing (Sheet number in Drawing Properties) when copying it inside the same project. A retag all and wire numbering on that drawing would help a lot making it a smooth option when re-using drawings inside the same project. Not sure why the option was provided if it could cause so much harm to the database especially for somebody new to Autocad. I have used in the past Insert WBlocked Circuit but it is a bit awkward sometimes to do it for all the drawings you need to copy. I really don't see why is possible to do it using Insert WBlocked Circuit but not when Copying a Drawings.
In the title block update dialog you have to option to resequence the sheet number assignments. This has no affect on filenames, since filenames are controlled by the user and could be in any form. But you can move up and move down o reorder drawings in a project and then run the title block update and choose the option to resequence the sheet number (%S) values.