Copy multiple workbooks/worksheets into one summary workbook

Hi,

I'm new to Macro. At work, I have about 30 workbooks (each contains 1 to 2 worksheets) that I need to copy into one summary workbook each month. 1) How can I record a Macro to copy the 30 workbooks into the summary workbook? 2) Can I run the Macro without opening the 30 workbooks?

Thanks.

Yes, the 30 files are saved in different folders.

Let's say I have a summary workbook named WB-MasterFile. Within the WB-MasterFile, I have 30 tabs labeled as WB-1, WB-2, WB-3, WB-4, etc... I also have 30 different workbooks named WB-1, WB-2, WB-3, WB-4, etc... I need to copy workbook WB-1 into WB-MasterFile tab WB-1, copy workbook WB-2 into WB-MasterFile tab WB-2, etc...

Thanks.