VBA: Copying Worksheets from Other Workbooks

[Dustin_D]

So every month I have to copy single worksheets out of multiple workbooks and considate them into a single workbook that I can then distribute. They are updated versions of the previous month. Each month they are in a new, but that folder is just copied from last month. (i.e march folder: Workbook a, workbook b etc / april:Workbook a, workbook b etc) Workbooks and worksheets always have same name.

I found this thread, but the file path changes each month.
http://www.mrexcel.com/forum/showthread.php?t=532242

Any help would be appreciated.

Thank you,

Dustin

 

[Dustin_D]

All I really want is so that when I change one worksheet in one work book, it to be automatically updated in the other workbook.