Automatic Generation of Excel sheets based on filtered Access Query

I have Excel Dashboard template that is reading from an access query. Every time I need to filter the access query by a variable value and refresh the connection in excel to update the dashboard with the filtered data. I need to automate this process by creating something that can loop the filter in access, refresh the connection in excel, save as the excel by the name of the filter value and repeat this process till the filter values are all done.