Update master sheet from sub sheets

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

If they are all saved in the same network folder... You can write a formula that references the other sheets.

Please Login or Register  to view this content.

If you have both sheets open, you can start the formula and then click the cell you want to use in the second sheet, excel will input the file name and cell address.
Note - if rows or columns will be added to the forms as the are updated - it would probably be best to reference the cell you want to use in a seperate sheet in that workbook

Please Login or Register  to view this content.

- that way if the initial cell moves (ex: a1 to a3) the reference formula will update

Please Login or Register  to view this content.

Sorry if I didn't articulate well
There is probably a better way to do it using macros - I would guess Access would be a better application for this type of thing