Data update in active sheet and also to master workbook through vba

I have master file and sub working files more than 10 i want retrieve the data to master file from user working files

i have 10 sub user files working on when the save the updates it has to also save to same workbook vba...

The value has to save by the look up value of e column contains some so_nbr values through the values from wokring file data move to master


e.g if master workbook contains 50 data it split to 2 user's 25 data to john & 25 data to steward.. When the click command button the data what ever updates in range f & g & h will save to master workbook to wards value of so nos in e column



please find the attachment


regards

any one help on this forum?