You can add camera shapes to the sheet. Camera shapes are created by taking a snapshot of the content in a range of cells. Changes in the cell range will update the content of the camera shape.

For more information, refer to Creating Camera Shapes.