Hi,
If you add more details then it will be better for understanding of your question/requirement.
But as far as I get from your question: There are a number of decisions involved at planning worksheet so better to be run manually and for required.
Regardless of this, you can execute any report or code unit in the background using job queue after regular intervals.