Complex Excel process automation

Can anyone suggest me the best way to automate complex excel reporting task?