This has been driving me nuts. I have a workbook that has multiple sheets, and I’m trying to create a “summary” sheet. I pull information from other sheets in the book, and I’m trying to ease the process by writing a formula that takes the name of the sheet that is listed as text in a cell that is in the same sheet I’m working in, and using it as the sheet name for the formula. For instance I want the data in Sheet1 cell B5…so I type $Sheet1.B5 in the cell, and I get what I want. But instead of doing this 70 times, I’d like to do something like this:
so that I can copy down the list of 70 or so cells. Is this even possible? I can’t seem to find a function or combination of functions to do it. The only thing close to what I’m looking for is T(), and it doesn’t seem to play nice with anything else.