New way to create a duplicate sheet that’s linked to an existing sheet but not using up more storage.

Right click a sheet and choose Mirror to New Book context menu.

A new book is created with the mirror sheet. It’s linked to the source sheet so it will update when source sheet is changed.

You can drag the sheet tab to other book to move it there. Or drag the workbook to other folder in Project Explorer.