Linking to SharePoint

[Shii]

I have a file that need to be updated with information available in another file on Sharepoint. This file name is saved by date 08-01-07; 08-02-07 etc. I created a Index...Match that pull the information but if the file's name was changed I am not pulling anything.

My question is:
How can I link my file, let call it A to B-08-01-07 on a sharepoint keeping in mind this file will change B-08-02-07 tomorrow?

My other question is how can I create a macro that will pull data from certain field in that file instead of using (=index...match)..

Thanks