scripting :%substitute

[IamJimbus]

I am getting much better at my regex/substitute work, converting access queries into SQL Server views to create SSRS reports, sometimes there's 15-20 queries per report. I've got it down to 6 or so :%s//g commands that I loop through and I'd like to set these up in some sort of script or macro to manage and execute them. How would I do this in this Vim?

Also, would it be reasonable to try and key bind a to something like esc;ggVG ?

TiA,

3