Is there any way to shorten this formula?

It’s just an INDIRECT and then a bunch of INDIRECTS within consecutive OFFSETS:


Since a lot of the formula is repeating, is there any way to shorten this? Even with a cheat or shortcut?
Here it is broken up into lines so you can see how repetitive it is:






For example, is there a way to put INDIRECT(“Main.”&CELL(“address”)) in cell A1 and then the formula would look much more condensed like this?:


Or even better something like this?:


I know the last two examples don’t work but maybe you’ll see what I’m trying to accomplish.