I have a worksheet with three cells that contain certain values.
What I want to do is to create an array (named range) of the three
cells.

E.g. A1, A2, A3 = myrange

and when I am working in a linked workbook I want to be able to enter
the formula like

=[external workbook]myrange(1) for the value of A2 or ...myrange(0) for
value of A1

Is this achievable?