Cell References

@daniel

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.

Paul Newcome

You may be able to use an INDEX/MATCH with x-sheet references for this, but I would need more details. What kind of data are you referencing, and how are you determining exactly what to pull and when?