I reduced the name of the referenced worksheets to a single character
and to my amazement Excel recognised the reference.

If I only knew why... :)