The Paste Special feature can be used to quickly link to range of cells from another sheet.
In the example below, we have a table on the sheet labelled First. We want to link to the bottom row from the sheet labelled Second
Select the desired range for linking b9:D9, then select Edit – Copy
Now go to the sheet from where we will be linking. Select the start cell of the new range (corresponding to B9 )
Now select Edit – Paste Special.
The Paste Special dialog is shown below. Select the Links option on bottom left.
The end result. The equations are for illustration. This may seem like overkill for a few cells – but can be very useful if yu have a very large range of cells that you need mapped to another spreadsheet.