I am working on a way to better manage employee's workload, and one of the things I want to do is see if they are behind on their assignments to jump in and help out if needed. Each employee is assigned tasks that have to be done at certain times, and curently the only way we have to view them is in our tracking system, which does not update with when things are next due, and does not show the cases in the order they were last updated. Since we need to make sure they get updated after 30 minutes, this causes a lot of wasted time spent flipping back and forth between cases (which take a while to load). I was wondering if there was a way to set up a separate file for each employee in one folder, then have a master file for the supervisor to view. I would like to set it up so that the employee would enter their assigned case information, along with the last time it was updated and the time it should be updated again, and the information they enter would be sent to the supervisor's master sheet. I don't think it would do it automatically, I'm sure the employee would probably have to save it and the supervisor would have to somehow refresh the sheet periodically (or would they have to close and reopen the file for it to update?) Is there a way to set this up so that it is pretty much idiot proof (the employees wouldn't have to mess around with macros or formulas or anything like that)?

Thanks for the help!