Automatic updates of data across multiple spreadsheets

I believe my boss is asking me to do something impossible with Excel, but I wanted to ask to make sure.

I have a series of spreadsheets I'm creating. One is 46,000 lines of data, and has a few versions. A few dozen have 2,800 lines of data. And Then there are about 70 more spreadsheets based on data from the 46,000 line and 2,800 line spreadsheet. There are pivot tables for many of the spreadsheets (the workbook has three tabs- two table-format worksheets, and one pivot table worksheet with slicers).

There are column label categories common to each of the spreadsheets. For example, the 46,000 lines represents 46,000 contracts. Each contract has a contract number. Each contract number is associated with a contract name, names of several levels of managers, and some financial data, among other things.

My boss would like when I change one piece of data for that piece of data to be updated on ALL of the spreadsheets.

For example:

Let's say we discover contract #100, for Acme Computing, is listed as having Manager Joe Smith. We learn that it should really have Manager Anne Jones. When I go to the line with Contract #100 and update the Manager column to say "Anne Jones," all of the spreadsheets with Contract #100 update the Manager column to say Anne Jones. This is done without going into every single one of the hundreds of spreadsheets and manually changing that piece of data.

Is this possible?

Thanks for your help.

I should also clarify that he would like all of the pivot tables to automatically update that piece of data, as well as the table-format worksheets.

Also, the Manager column may be a different column in different versions of the spreadsheet, as some spreadsheets have more or less data than others. So Manager might be column G on one version of the spreadsheet, and column H on another version.