Create link with sheet which is not inserted into workbook

[Guest]

I have a workbook containing Sheet 1, Sheet 2, Sheet3. If I write in cell A1
"March"
of Sheet 1 and then put formula (=Sheet1!A1) in A1 of Sheet 2 it gives
"March" in result. And if I put formula (=Sheet4!A1) then it result #REF!
because Sheet 4 is not inserted. Is it possible ? If I insert Sheet 4 and
write "March" in cell A1 automatically #REF! turns into "March" without
changing formula of cell A1 of Sheet 2.

 

[Guest]

You are correct that if the sheet has no where to reference it will come back
as #REF. Once the sheet is inserted into the workbook it will read what ever
is in that cell. If you are wanting it to be the same as Sheet1A1 I would
suggest using the same link to Sheet1A1 for less confusion down the road.