Filter Data into separate workbooks

Hello,

I have an excel spreadsheet with data of all of the companies in our organization, I would like to filter the data into different workbooks by company so each manager at his / her location can view only their information. The main spreadsheet is constantly updated and I need the excel workbooks to continually update as well with the new information. Any advice anyone has would be much appreciated!!

Thank you!!