I feel that there is an efficient way to do this but I can't work it out!

I have a large number of indirect cell references which I would like to replace with the cell reference which they solve for (e.g. ='sheet 1'!A1) But I can't work out an efficient way of doing this. I focussed on formulatext + paste value, to no avail.

My indirect formula is:

=-IFERROR(INDEX(INDIRECT("'"&J$4&"'!m7:m1000"),MATCH($C47,INDIRECT("'"&J$4&"'!K7:k1000"),0)),0)

There are a small number of:

=INDIRECT("'"&$P$61&"'!"&CONCATENATE(INDEX(W$63:W$67, MATCH($L80, $N$63:$N$67, 0)),$N80))

I am able to replace them by hand, will take 4 hours but I am worried that it will have a large risk of error and would like a formulaic solution?

Thoughts appreciated,

A