yes

the problem i think is you are using copy paste...

=Sheet2!A1 - use the fill handle to drag down the formula

fillhandle.gif