cell a1 has the name Jones in it.

in b1 I would like to have the following formula: =a1 (plus add the
following) !b28
so that the name jones is returned in b1 looking like this: =jones!b28.

I hope I explained my question adequately.
I am a complete novice.

Thank you,
Brian