Same thing different method: Copy N5 and in B1 Paste Special - Paste Link.
Edit: Actually not exactly the same. With above method you get =Sheet2!$N$5. The $-symbols is a reference used when you copy cells in reference to other cells. What I mainly meant to show was a simple way to link your cells.