Multiple workbooks information feeds into one master workbook log

Hi, I have multiple workbooks with information that needs to be automatically added to a master workbook tracker. Information that is inputed in the various workbooks is by data validation with dropdown menus. I need to be able to add something to a workbook and then it automatically add that info to the master workbook tracker. Can anyone help me with this. Its only with three fields of information. Thank you very much

Here is the example input of what I am trying to automatically copy to my master workbook. Also this iformation is coming from several different workbooks into one workbook. Thank you for your help very much. I know little about excel so bare with me.

The master book looks the exact same, it just tracks the total informtion from all the company workbooks

Well here is the problem. Each workbook is a roster of everyone within that company. The intent is to just let the companies make changes to their roster or add new people into their roster and it automatically update in the master workbook. I suggested the idea you posted to my boss, but he still wants it the other way. Is there another route I can take so that the new people added to the workbooks will automatically be added to the master workbook. Thanks for your help again.