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.