|What do mean when you say "the formula doesn't work?"|
When you enter =Sheet1!A2 does it not return the value from Sheet1!A2? What does it return?
Is the cell formatted as text by any chance?
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.