Hello,

I am new to VBA code and I am trying to automate a report where a slicer for Market data selects one at a time and copies the entire sheet to a new workbook naming each sheet as the market selected in the slicer. I have tried a couple variations of loops and it keeps breaking. I usually use Excel 2013 but for this report it has to be done in 2010. Does anyone know how to do this?

Thank you!