HI All,

I am trying to do the following using VBA if someone can help me.

I have ‘FILE 1’ in ‘FOLDER A’.

I want to copy the whole ‘FILE 1’ and paste it in FOLDER B, and call it ‘FILE 2’ but I want It to be a valued version.

Then from ‘FILE2’ I want to move ‘Sheet2’ and ‘Sheet4’ in to another file and name it ‘FILE55’.
Then from ‘File2’ I want to move ‘Sheet5’, ‘Sheet6, and ‘Sheet8’ into another file and anme it ‘FILE66’

And so on.

If you can help with the VBA that can do this I will be able to adjust it to how many times ill need to move the sheets around. Thank you very much!

Remember, I do need a valued version first before moving sheets. I can remane it based on what word is in cell A1 as well would be great. But top part is more important.

Thank you!!!!!!!!