I have a summary sheet and I would like that every time I add a new sheet everything gets referenced to the summary sheet. I have used
indirect to do this, the only flaw is that once I add a row, the formula doesn't update so I would have to update the formula each time in the summary sheet. Is there any way to fix this?
This is my formula now:
where A33 is referencing the sheet name and H44 is what I want to be updated when I add a row in the sheet being referenced. I hope that makes sense!