Excel's Camera Tool

Excel has a camera tool that you can activate by going to File . . . Options . . . Customize Ribbon.

Set the menu on the left to 'All Commands' and then scroll down and find the Camera tool. Create a new group on the right and Add the Camera into it.

Select a range of cells and then click on the Camera icon.

When you click on a new sheet an image of the selected area will be added. Clicking on the image will take you back to the original source range.