Not in that straight manner. But with some 'reference' formula. I hope I had explained. i.e. by referring cell Sheet1!D4. I think there is some formula which will get values of of moving right/left & up/down.
I think there is some formula which picks up value n columns right/left & m rows down/up. Using this formula PROBABLY, the answer may come. I want to get In Sheet2!A3, value of Sheet1!S38.
I have Sheet2!A2=Sheet1!D4.