418100 Programming Excel

Hello, I need help with a programming issue and Excel. Say I wanted to update a spreadsheet daily. First I would need to automatically download CSV from Google AdWords and similar sites on Yahoo and Microsoft. Are there API calls to do such a thing? Then I would take the downloaded spreadsheets and copy and paste a cell in one spreadsheet and then paste it at another cell location in another spreadsheet. Then save and exit. Can this be done with VB or ? Please let me know if you can do it and if you have a specific example of how you implemented your solution. Thank you.