The INDIRECT function is a great way to create links between worksheets within a workbook. You can use information you already have in your spreadsheet to create a reference. The reference created using the INDIRECT function will stay the same, even if your sheet's structure changes. More @Wikipedia
Hover over any link to get a description of the article. Please note that search keywords are sometimes hidden within the full article and don't appear in the description or title.