Need to modify VBA Code that copies multiple sheets to a master sheet

I found the code below and it works perfectly if I want to copy all the other sheets to a master sheet. But, I need to specify specific sheets. Basically I have a workbook consisting of multiple sheets and multiple "master" sheets so I need to specify in the code which sheets it should be copying.

Please Login or Register  to view this content.

I have found this question asked before but never ran across any useful answers. I am an extreme rookie when it comes to VBA.
Any advise would be greatly appreciated.

Thank you so much for your reply. I will definetly make note of this. It could come in handy in other situations. But, in my current case I will end up with 6 "Master" sheets that will each have any where from 5 to 10 sheets that will need to be copied to it. Listing the actual sheets would be a better option. Could I ask you to provide a code sample of the follow scenario?
Master sheet is named "Master"
Need to copy from sheets named "A", "C", & "E"

I'm not that good with VBA but trying to learn. Its about my only weak spot when it comes to Excel.

Thanks a Bunch,
AXGirl

Perfect!! Works like a charm. Thank you so much for your assistance.