As if that wasn't confusing enough...

Sheet 2 has a value in A15 which it's reading from Sheet 1's A15. How do I
copy Sheet 2 to a new sheet 3 so that Sheet 3's A15 points to Sheet 2's A15
and not Sheet 1's? How do I make the "=+Sheet1!A15" a relative value?