I’m looking for some help with a macro. I’ve used a similar macro about 5 years ago and cannot remember what code I used for it.

I’ve got an existing macro report with a front page where performance information can be generated based on criteria such as data ranges and also by sales rep.
What I’m looking to do is create a new macro on a separate tab of the same workbook where I can extract the Sales Figures by Sales Rep into a brand new workbook. Each Sales Rep should have a new workbook created showing only their figures. So, for example, the click of a button would start a macro which would link to a fold, and I’d see something similar to this PaulSales.xslx, JodySales.xslx etc.

Your help would be much appreciated.

Thanks

Below is the front screenshot of the existing Macro where the detail will come from.

Tried a few functions from what I can remember but my memory isnt great