Hi all

I am making some improvements to efficiency within my office, and the project I am currently working on could be so good, if I can figure out one thing! I shall explain what I am trying to achieve and hopefully someone can help!

I have:

A Master Spreadsheet (which acts as an internal intranet, of which I open in the morning and then 10 others open the read only for use in the day - this stays open)
A sales tracker (which is opened for every sale and then added to the tracker)

What I would like:

To be able to update the sales tracker, close the sales tracker and this then updates a tab within the master spreadsheet for all users, whilst still open.

Is this at all possible? I just want a live feed to the "intranet" for everyone to be able to see where we are at any point in the day.

Hope this makes sense, and hope its possible!