Linking multiple Excell workbooks

I have one master workbook and 10 dependent workbooks. What I would like to do is have the dependent workbook automatically update with specific information from the master. I am trying to generate sales reports for individual salesmen. The master is set up with simple columns date/customer/product/price/sales#. I want excel to only pull only the information a specific salesman and place it in the dependent workbook. All workbooks are set up identically. Thanks for all your help.