Copying and deleting worksheets
When you copy a sheet, insert the copied sheet after the original sheet. This will help prevent the confusion of which sheet has the active view on it.
Before deleting a sheet, ensure that all views on the sheet have been deleted first. This will keep your workbook names list clean.