All of these can be done. And though one could manipulate data in an Excel workbook without 'opening' the file, I'm sure you are just wanting to automate the process, and avoid having to manually open each file and make the changes.

Having said that, your request looks more like a project than a need for guidance. You'd be better off offering an amount as reward for getting the work done.