I  am describing what I am  doing weekly since I would like to automate the  
following process. is there some kind of a script that can be saved that
would remember my key strokes and/or some other way to automate this process/

Right now I run queries on sql server and copy and paste the results into
excel spreadsheets. I copy the detail information from sql server into the
excel spreadsheets and I also right click on lots of pivot taboles so that
the data is updated in the pivot tables.

Thus let me know if this can be automated and how to automate this process.

Thanks!