I'm trying to reference a sheet using a cell value, but it doesn't seem to be working. Is it possible?
Cell Value: "Test Sheet"
I want to reference different rows based on the first cell value, basically retrieving different cells from that one "Test Sheet" -- the reason why I want to do that is so I can just copy/paste all of the other references (that are referencing Cell1 for example). See screenshot. I just want a dynamic way of referencing all of the cells, because as we scale - it needs to have some level of automatic. I can't click on references for all of these cells in each of their sheets - that would be too much work.
