Matrix compression (formula to lookup and compress values)

Hello,
I need to copy data from matrix to compressed matrix (less colums, basicly same data). Matrix is huge so I can't do it manualy. Old matrix contains employees list and group of activities required for Line training. New one contains emploees list and positions Like Line 1, Line 2 ect. New matrix should show wheter person was fully train for its job or not.

To exctract information wheter all required trainings were performed I use this function:

=AND(EXACT(MATRIX!DL4,MATRIX!$I$1))

But how can I relate it to employee number from the list so I always have right info in new matrix, no matter how the old matrix will be sorted?

Old Matrix.PNG

New compressed and linked matrix:
New Matrix linked to old one.PNG