inserting Sheet names

[jkmclean]

Is there a way to insert the names of the sheets into formulas.
for example on sheet 1the formula is A30 has if(a2<a50game,if(a5>49,"***",""
There are hundreds of cells with formulas, and want to know if there is a way to
have the formulas updated to if(sheet1!a2<a50game,if(sheet!a5>49,"***","")
I want to copy the data to another sheet and keep the reference to the original sheet.

<colgroup><col></colgroup><tbody>
</tbody>

<colgroup><col></colgroup><tbody>
</tbody>

 

[DanteAmor]

Press Ctrl + L to Find and Replace.
Find Wath: (
Replace with: (Sheet1!
Look in: formulas
Match entire cell contents (off)
Replace all