Export targets for Power Query

I encounter lots of clients that has to export the result of Power Query work out to regions or channels in their respective companies. This is painful as filters in the table has to selected and each filtered set saved, then mail. The only way currently is through a very painful trial and error homegrown VBA style app. Not all of our clients can or want to sign up in order to share Power Query queries. They just want to send their operational reports asap