I am trying to figure out a formula to reference information in a specific cell of the last worksheet. The formula is for a summary sheet at the beginning of the workbook, referencing the same cell of the last worksheet in the workbook no matter the name of the worksheet. A new sheet is created every month, updated with the information and changes from the previous month. The worksheets are all labeled "Pay Estimate 1" and so forth.
Asked
Active
Viewed 47 times
