Suppose you maintain a monthly workbook that uses one worksheet per day to track key metrics such as sales, expenses, and so forth. At the end of the month, you'd like to build a summary worksheet that accrues the totals from each daily worksheet. While it's easy to link from one worksheet to another, building links from each of the 31 worksheets one at a time would be fairly tedious. That's where the INDIRECT function can come in handy. If the text contains a valid named range, Excel will return the value found at that range. The link to another worksheet will contain an apostrophe, the worksheet name, another apostrophe, an exclamation point, and the cell address. To build the argument for the INDIRECT formula, you need to replicate the reference from your temporary formula. While INDIRECT can be used to pull values from other workbooks, those workbooks must be open in order for the function to work.