Linking a workbook's data to many other summary workbooks when creating it

[Joaquin Phoenix]

Hi,
I have to manage a real estate portfolio and need to constantly update the property database.
This means creating a new workbook for each house with all her information (basically rent collected, and costs) which is more or less quick; the problem comes when I have to link that data to 5 other summary workbooks which allow me to keep track of all the properties 'data. I made an oversimplified sketch of how the system works in case it remains unclear.
My objective would be that when I create a house workbook its information instantly becomes linked to every other summary workbook so that instead of having to change 6 books I only have to change 1.

Thanks in advance for the help.

 

[teylyn]

How many workbooks are you handling? How about creating one master workbook that pulls all the information from the different individual house files, then create reports that reference only the master workbook.