Auto-populate data into seperate workbooks in excel

Hello,

I need to have seperate work books populate data from multiple master workbooks automatically. Attached is one of the Master Workbooks (Each school has a master) and a Provider workbook (each provider has its own work book). I will be updating data on the master workbooks and it needs to update the corosponding provider workbooks with their schedules automatically. Theres multiple providers per school and schools per providers.

ThMasterTemplate-test1.xlsxProvider.xlsxank you!