Sync Data from One Spreadsheet to Another

I created a 10 spreadsheets for 10 companies that include 25 columns of info each and multiple tabs.

I need to create a master spreadsheet, which contains info from all 10 companies but only 10 of the columns are necessary. I want to ensure that if a change is made in the master spreadsheet in one of the columns for company "A", that change is reflected in their personal spreadsheet as well, pretty much syncing info typed in one worksheet to a spot in another.

Is that possible?

Thank you,

Zanna