Hi

I have a master sheet that has around 30 or so tabs, I want to have a macro that will copy each of these (values and formatting only) and save them as individual workbooks and generate the file name based on cells B2 and C2.

IS this something that can be done?

thanks in advance