maybe you could use some code like this to create your link based on the sheet
name instead of hard coding it
sheets(1) is the first sheet, so if the order is always the same, the name won't
matter.


nm = Sheets(1).Name
Sheets("sheet2").Range("a2").Formula = "='" & nm & "'!" & "A4"

if the sheet name (nm) changes, the formula still works
--


Gary


"Spike" wrote in message
...
I have a workbook A comprising one worksheet that is linked to another
workbook B of six sheets; there are several links from A to each sheet in B.

Workbook B is generated by a macro on another workbook and saved down with
the same name so it overwrites the previous workbook B. However the sheet
names change slightly to reflect the date of creation; so the first sheet
will change from Sheet1Name+old date to Sheet1Name+new date and
Sheet2Name+old date to Sheet2Name +new date and so on.

I have workbook A open as i am running a macro already on that workbook and
then go to the other workbook to run a macro to create a new workbook B. How
do i get workbook A to update all the links automatically to the new workbook
B. I can get to the dialogue box 'Select Sheet' 'select the sheet to link
to:' Is it possible to use a macro to select each sheet in turn in the
dialogue box.

If it is possible i will be really grateful for the relevant code.

Many thanks
--
with kind regards

Spike