Copy Data between two workbooks (Wildcard windows().Activate)

I've seen it discussed in a couple threads how it is possible to copy data between two workbooks (open or closed). In my case I am trying to create a macro that copies data from one open window called *month_todate*.xls to another open window called *affiliate*.xls.

When I tried copying this data from one open workbook to the other, the windows().activate command would not allow wildcards. How can I make sure that I can apply this to many workbooks one at a time that either have affiliate in the title or month_todate in the title?

Here is the code I currently have that works when I change the wildcard names to the actual file names:

Please Login or Register  to view this content.

I'm not quite sure I understand how this code works and what I am replacing it with?

Does anyone know how I can make these changes so I can apply it across multiple workbooks?