How to Copy a Column From One Sheet to Another in Google Sheets Easily
Too Long; Didn't Read
Use this script and HTML codes in your apps script for the spreadsheet. It will automatically copy your column from one sheet to another also with respect to other unique columns like ID, and email.