U can use the worksheet_activate event of the Summary worksheet. Using VBA
code you can use the sheet number to determine the most recent Detail sheet,
or some other unique pattern. Then you can update the formula in the Summary
sheet with the correct reference. Jason