Hello
I would like to type a code into a cell that would then paste text from
another sheet.
Is this possible if so what is the formula.

Example: I would like to enter this code ARTW1G1
and then the text entered into that cell would be
Joe attended ART lead by Jane (RCC). The learned the SLT skill Helping others.

Does what i am asking make sense. Thank you.