Copy sheets from one workbook to another using a macro

[patrick200]

Having a problem.......Trying to create a macro to copy sheets from one workbook to another.

For example

I have a workbook named CHGOVR.xlsm stored in S:/DATA/ CHANGE
I'm trying to copy very hidden sheets 2 to sheets 30 to a workbook named TEST.xlm also stored in S:/DATA/CHANGE

I've tried to record a macro (still new at vba) but I have to open and close workbooks, which I would rather not do.
I'm assuming there is vba code for this. I'm not sure where to start????

Any help would be great......Thanks in advance........Pat