semi automatic seizure excel

I have a list on sheet 1 and I want in each first column of the workbook there is a semi-automatic entry in relation to this list.

How to do please?