Hi
If I understand you correctly you need to consolidate multiple datasheets into one summary sheet. If there are only ever 5 sets of data per person I would suggest that you have a Master Worksheet setup that contains links to each persons five sheets of data sheets. That way as soon as they update there data sheets your Master sheet updates automatically whether it is open or not.
For this to work the location of the Master and User Workbooks need to be on the same network constantly.
If you need any help setting this up let me know.
Good luck.
Tony