i need to use a formula in which the variable part is the worksheet name, i'm
trying to use INDIRECT($A$1 & "!A2"), where the value of $A$1 is the
worksheet name, but when i copy my formula to the other cells, the A2 part
does not update

how do i make it automatically update to the current cell reference?