I have a problem where I need to reference a cell in a matrix, and then I need to be able to copy both the reference cell and the matrix to a new destination (either a new spreadsheet or shuffle it around a few cells) but keep the relevant references in the matrix.
So as an example (see image)...