Select & copy spreadsheets to new folder

[heliskier89]

I've had a quick search but can't see anything that fits my needs and would be grateful if some of you clever guys could help!
If A,B,C,D etc were the names of 4 different spreadsheets, what code would be required to copy A,B,C,D or any combination (ie B,C or A only) and place them in a new folder that I could name?
In addition to this I would like to be able to select the spreadsheets to copy from another spreadsheet by possibly clicking a button next A,B,C or D.
Any help would be appreciated.

 

[VoG]

Any help?

FileCopy oldFile, NewFile

 

[heliskier89]

Thanks for taking the time to reply but I'm not sure if I explained my problem correctly. I've tried to attach a snapshot of a rough layout of the workbook to aid explanation but failed! I can email the spreadsheet to anyone who is interested.
Basically, I want to select any one or all of the buttons marked A,B,C & D. In this instance I've selected B & D. The A,B,C & D buttons represent the 4 spreadsheets listed in the tabs at the bottom. Note I've used Form Control buttons for this purpose.
After selecting B & D (or any other selected) I then want to copy spreadsheets B & D and place them in another folder / workbook when 'Button 6' is clicked.