Ask Your Question

Revision history [back]

One solution could be to not use a literal string in the formula expression but a cell reference or better a named cell that contains a sheet name to use. So (under Sheet -> Named Ranges and Expressions) define a named range SheetName or some such pointing to, for example, A1, and let your formula be


To help the user you can setup data validity for A1 (under Data -> Validity) and define a list with possible sheet names. Best and easiest to maintain would be to use a cell range that contains a list of names, so for Criteria, Allow, select Cell range and specify the cell range reference as Source.