Hello,
I have a workbook with many worksheets which all have very unique names. Certain data from each sheet is collected onto one sheet for an overview. On the overview sheet, I would like to be able to type the following function, =SUM('A2'!L$23:L$25), where A2 refers to a cell which has the same name as the sheet of interest. This way I do not have to type in the sheet name in all the overview cells. Obviously this formula will not work, as I have tried. Any ideas on a formula which will accomplish what i am looking for? Below is a sample of my overview sheet, where the numbers 78 and 46 exist on a sheet with the same name as Sheet Name. So instead of typing =SUM('Sheet Name'!,L$23:L$25), I would like to type something like =SUM('A2'!L$23:L$25). This way I only have to type the sheet name once and i can drag down the above formula and it will automatically select the data from the sheet name which my formula references.
Sheet Name 11/4/2012 78 46
Thanks
Andy
Bookmarks