How to use Excel to make two workbook's information can automatic fill in between each other?

Hi friends, can you all teach me ho to use Excel to make two workbook's information link together?

For example in workbook A, it is show four component which is CUSTOMERS, STYLE, ID, and ART NO. Worker A will key in the information of CUSTOMERS, STYLE, and ID, into workbook A Worker B is from other department, worker B will fill in the ART NO after worker A key in the information above. 

When worker B open their own workbook,here we call workbook B, worker B will select a customers's name(For example customers A), then all related information will automatic get from workbook A together with the STYLE and ID of the customers A also.

After, worker B fill in the Art No, the worker A will get the information of  Art No in his workbook A after refresh  the Excel file.

So,the problem is, How I make two workbook's information can link together? Thanks for those are helping me!