Learn Excel Episode 681: Indirect
Kambiz sends in a question. He has a Summary worksheet that points to Jan, Feb, Mar worksheets in his workbook. When he copies the worksheet to a new workbook, the formulas keep pointing to the Jan worksheet on the original workbook. In Episode 681, we take a look at using the INDIRECT function to solve this problem.