Hi, hope this makes sense:

We use seven identical workbooks (each uses our name) and we record phone calls in/out during the day.
The eighth book (Master) consolidates all the information from the others at the end of each day, to do this someone has to copy the data from each persons sheet and paste it into the Master sheet then sort by date/time for the boss.
Is there any way (we are on a network) of filling the data on my sheet and this either automatically or by pressing an "Update" button transfer the data direct to the Master sheet? Of course, potentially 7 of us could be doing this at about the same time!.

Any help or advice would be appreciated

Thanks
Tony