Macro to extract data from another workbook, specific to user

Hey guys,

My mind is blank when it comes to macros - as a rule I turn to google and simply copy and paste the macro, but I cant find one as this request is quite specific.

I have a spreadsheet where work requests are logged – this is filled in by multiple people, detailing their request and tracking it along the way. One of our guys needs to extract this information on a weekly basis to provide a report to the client – obviously he could do a filter then copy & paste, but a simple macro button would make his life much easier as he isn’t excel savvy.

What code would I need to run this?

Thanks!