Hi,

This is probably a really easy thing to fix, but I am seriously struggling.

ISSUE AT HAND
What I need is to have a worksheet (call it totals) that contains values
from a multitude of other worksheets (call each of them company). This has
been working just fine. However, I realized that since the filenames change
every month (i.e. From 04-08workbook.xls to 05-08workbook.xls) I could make
it so I don't have to manually update the cell references:
in the "totals" workbook there are cells that refer to sums in each of the
"company" workbooks and these "company" workbooks are the ones that have the
aforementioned name changes.

MY FAILING SOLUTION
So, what I have tried to do was I got Excel to have a date cell formatted to
have {=now()} formatted to mm-yy and I tried to put in the information for
that date cell and file extension into the desination cells in the "Totals"
workbook with no avail. I have also been trying to write a macro to paste the
the date and file extension into a workbooks.open filename = _ paste
which has also not worked. Logically it seems that either method would work,
but I feel that the different properties of the open filename and the
destination cells are not compatible for what I think is logical.

Do you have any suggestions as to how I could get this to work? It would be
greatly appreciated