Hello! Welcome to one of the best places on the entire internet. Have you tried creating a macro to do that but are getting stuck on a particular step? Generally we try to help folks learn how to fish so I'll post some links that @ccstone usually posts that are really helpful for getting started.
If you haven't seen these they're worth a moment of your time: