Transfer Text From Changing File Name

I have Workbook1 that I need to update from another Workbook2 in a different location on the network. Workbook2 is read only. Workbook2 is generated automatically with a name like "product 06-14.xls". Now my problem is that, since it get created automatically, the next day it will create a new workbook with a new name "product 06-15.xls" leaving the old file in the same directory for future reference.

I need to update a cell with the new current date up to the completion of the month plus the beginning of the next month to make it a complete month, so a completed month will be from 05-01-2006 to 06-1-2006 because the last day of the month doesn't get recorded until next day. What I have problems with is the looping to go to the next day until the beginning of the next. Then stop and start again on a new cell inputting the new month.

April-06 ---- 5,907
May-06 ----- 4,954
June-06 ------ 524
July-06 ----

This is what I have so far.

[PHP]
Sub GetData()
Dim Cel As Range
Dim Row As Long
Dim Col As Long

'Turn off ScreenUpdating for faster macro runtime so screen won't flash while running.................