Select the Range (Cells in another worksheet within the same workbook) and
create a "name" for this range (something like that on menu:
"Insert>Name>Define" - I don't know how is in english).
When you create a link, select the same file and the name that you created