Sorry I should have added I thought this was a challenging ask, and wanted some ideas of what might be achievable.  I personally have never dealt with those report volumes...

Thank you both for you input, it is much appreciated.