I have four sheets each with its own name which corresponds to the left cells. I want to reference those sheets by only stating the left cells. For example, instead of having
='SIN PLANIFICACIÓN'!E118 in
C3, I have something of the likes of
=$B3!E118. So I can drag this formula down and automatically reference other sheets.
How can I do this?