Master data should get in another sheet in separate file in a folder

Hi,

i have an excel sheet with employee master data. i want few columns of this sheet in another sheet of same excel and as a separate file in another folder.
ie in attached file --> employee master sheet data should be automatically fill in email id sheet of only active employees.when an employee becomes inactive in emp master the same data has to be deleted from email id sheet.
the same data should be generated as separate file in another folder ie only email id sheet.

support me.