Create different views of data by creating several report workbooks that only link to pertinent data. You can reference cells or a defined name in another workbook or the same workbook. The destination workbook contains the workbook link. The workbook link refers to a cell or range in a source workbook. 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.