Automating reports

Hi
I need help with automating reports in excel, I have followed every article I can find on the web and still I'm stuck.

Please can someone help me, I need to Automate media industry reports on a monthly basis.

Hi
could you be a little more specific please?