I have a a very large spreadsheet that pulls data from another logsheet through an
Indirect depending on user input on cell A1.
I'm trying to add some new columns now to the logsheets, when I manually type in the sheet names
It automatically updates the
$AG$3 part when I add new columns, but with
indirect() it does not. Is there any way using
indirect, or some other formula, where I can get Google Sheets to automatically update my referenced cells?