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.
[TABLE="width: 61"]
<colgroup><col></colgroup><tbody>[TR]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 61"]
<colgroup><col></colgroup><tbody>[TR]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[DanteAmor]

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