I am attempting to create a summary table worksheet from all the other worksheets within my excel document. i.e. I have a "Summary" worksheet and then a "001", "002", "003"...etc. In one column of my summary worksheet I call out the name of the worksheet that the row refers to. Within this row, for various cells, I want to be able to use that first cell reference (i.e. the name of the worksheet) to have excel find that specific worksheet and then grab a number with the reference specified.
For example: if I were to write it as a normal function it would be ='001'!C5 and this would find C5 for the worksheet named 001.
But I want the 001 to be read from the first cell of the row. If we assume A3 of my "Summary" worksheet has a value of 001, then I want to be able to type into a cell in that row something like ='A3'!C5 where A3 would equal 001. But written this way, excel will be looking for the worksheet named "A3".
Any thoughts on how this function could be written?
Bookmarks