Ron,

Thank you for your response.

Example 1 is the closest to what I am looking for.

However, we have over 450 spreadsheets that need to be linked to - this number does vary from week to week, both up and down. Would there be a way to create a macro that looks for all excel files within a folder, and it's subfolders, and create the links?

Thanks again
Paul Grewer