I have multiple worksheets.

Sheet1 contains:

System Group Level Status Description
SYS1 SF99530 0007198 4 CUMULATIVE PTF PACKAGE C7198530
SYS2 SF99530 0007016 4 CUMULATIVE PTF PACKAGE C7016530

Sheet2 contains:

System Current CUM
SYS1
SYS2

How can I have sheet 2 automatically update based on referencing and
trimming cells in sheet1 to result in:

System Current CUM
SYS1 C7198530
SYS2 C7016530