So I am using the below syntax to pull certain information. I am able to get the correct answer however, when I drag the formula to another cell, indirect ref doesnt move from A2 to A3, A4 so on and so forth. Would anyone have an idea?
VLOOKUP($B$16,INDIRECT(A2&"!A$1:C$50"),3,FALSE)
VLOOKUP($B$16,INDIRECT(A2&"!A$1:C$50"),3,FALSE)