Take the 2-minute tour ×  I want to reference a cell in another
sheet, and the formula I get when pressing = followed by
changing sheet, clicking on the cell and pressing Enter, gives
me   Which is fine, except that cell B3 in Sheet1 contains the
name of the sheet to select from.  So how can I avoid hard
coding the name of the sheet and instead use the value of a cell
as the sheet name?  I've googled and looked up OOo documentation
and wikis, but to no avail.  share|improve this question
possible duplicate: superuser.com/questions/371970/… – 
tohuwawohu Jul 12 '12 at 4:44 Not a duplicate, but related in
the use of INDIRECT for the solution. But this question is
specific to referencing another sheet, for which special syntax
seems to be needed. –  jgivoni Jul 12 '12 at 9:33 add comment  1
Answer  up vote 2 down vote accepted  What you're looking for is
called an Indirect Reference.   I believe would do what you're
looking for.  To explain, it's the concatenation of the string
value of cell B3 in the current sh