I see from the comment on a deleted answer that the spreadsheets to be updated are on other computers. This update is not possible in my opinion unless one writes a macro for the remote spreadsheets that checks regularly the modification-date on the source-spreadsheet and updates itself if required. The document in this case must be on a public network share and the job is far from easy.
Your other option, if all users have access to the Internet, is to use an online spreadsheet to collaborate on just one spreadsheet. There are various online products, even free ones, that can serve this purpose.
You should supply us with more details as regarding your environment and what is wanted or possible in it.