The one I highlighted in red. The In your sample A3 contains an "A". If you have a sheet named "A", the formula will indirectly reference that sheet so that it get the info required. As you drag the formula down, it changes to A4 and therefore it should get the info from sheet named "B", and so on...