Links and refences

[Oasisnutt75]

I wonder if anybody thinks this is possible.

In cell A1 I have a date, say 02012005, which can change as needed.

In a separate file I have a report c:\Data\Reportwe02012005.xls

Can I have a link in the current worksheet that references this date as it changes.

i.e. can the link read C:\Data\Reportwe"A1".xls?

I cannot seem to find anything that touches this. If someone knows or if there was a thread about this before, I'd much appreciate the information.

Thanks,
Paul