MIS Automation Software Required

We would like to automate below activities  Open URL  Login with user name & password  select the report and select start to end date  execute the report  after 15min – again login and select the same report and click on download data to download in fixed folder  once download the data just rename file (which name previous liked in access  open MS Access and run macro  once complete the macro, MS Access will export summary report in excel format and exit  open 1st excel and copy data form particular sheet and range  open 2nd and past data in required raw or column or end of the previous data  refresh pivot table and formula  select a fixed range data and copy form 2nd excel  open outlook new mail and past on the mail body  paste a gritting write-up like “ Hi, please find attached data or els “  Save excel and exit / close excel  Excel link in attachment  mention “To” and “CC” email ids  send email Below options also use in MIS Copy data from once location to another location Data copy from web portal and paste in excel File formats converter Excel commands automate like add or delete raw & columns Some data receive on mail which required to save attachment in a particular folder If data receive on mail body than copy from mail body and paste in excel Data zip or unzip Data share on FTP path and same Data copy from FTP and save on local hard drive Change reports URL password Data fill on web portal Send error alert on mail or SMS Summary data copy from excel and send on SMS Restart the system Schedule mail and schedule these all tasks to execute on time Schedule application to open or executive