Yes, You can do this refresh and extract at a time without doing any manual job.
Both Tableau Online and Tableau Server have Schedule refresh extract option where you can set it daily, weekly, monthly to refresh and extract.
Please go through this link. You'll have some clarification.
Please let me know if you need anything else.
Our organization hasn't purchased Tableau Online or Tableau Server. We are currently working off various individual licenses of Desktop and Reader. Can you think of any other work around without moving to the new systems?
Ohh, Got it.
I don't think so it is possible without having Tableau online or server.
Please mark helpful if my response helped you.