[speakingmoistly]

I've seen this posted a few times now, might as well leave the comment I meant to make the first time around: this sounds like a tool solution to a process problem. You're right in that it shouldn't take hours every week to communicate status upwards, but the solution isn't necessarily to automate the whole of it (although automation does have a role to play). The reason why it takes hours is likely because the process in place to do it is flawed (one common mistake that comes to mind is not accumulating notes along the way, which is very quick, and trying to catch up all in one go just before the deadline, which takes a lot more time and effort for a lackluster result). Fix the upstream issue and you'll never spend hours on status reports again.