Copy select sheets to another Workbook
 

I would like to copy a summary sheet to a monthly summary workbook. The daily workbook is named 010104, 010204, etc. The monthly summary tabs should be name 1,2,3, etc. Can this be done without opening all the files if they daily sheets are in a dir by themselves, and the same dir that the monthly summary will reside? If so, how?