Macros involve the automation of certain steps done manually in excel. You can have a separate macro file which will ask you to open the report and do the required steps and provide it to you.

If you need further help, attach a sample workbook (ensure that all sensitive data is removed) and let me know what you need automated and maybe i can help you out.