Master.xlsm

README.md

Put the macro in Master.xlsm

Add a PersonIDs sheet to Files.xlsx workbook

Run the macro after editing person data in Master

gistfile1.txt

Sub CopyColumnToWorkbook()

    Application.ScreenUpdating = False
    
    Dim sourceWb As String
    Dim targetWb As String
    Dim sourceColumn As Range, targetColumn As Range
    
    sourceWb = "Master.xlsm"
    targetWb = "Files.xlsx"
          
    Workbooks.Open targetWb

    Set sourceColumn = Workbooks(sourceWb).Worksheets("People").Columns("A")
    Set targetColumn = Workbooks(targetWb).Worksheets("PersonIDs").Columns("A")
    
    sourceColumn.Copy Destination:=targetColumn
    
    Workbooks(targetWb).Close SaveChanges:=True
    
    Application.ScreenUpdating = True
End Sub