Automating a bad process simply gives you faster bad results. The rule of automation is: Standardize, then Automate.
It moves data from Point A (source) to Point Z (final report) without manual intervention. big macro tool