automation

Are there any good (progammatic) ways of automating spreadsheet creation in Excel? I'm currently copying and pasting the output of 4 SQL queries into a spreadsheet manually; ideally I'd be able to automate this and then run a monthly job to generate the spreadsheets. I know there's a way to...