copying a link in a live document

[njsavage]

i need to copy lots of links from other documents into one 'live' document. eg

='E:\Nick PhD\Nick Data\Parotec\kane Testing\Final tests\RacB\Speed test (kph)\[01.xls]Summary'!$D$6

is the link in the formula bar. i need to drag the formula down so that the file number [01.xls] increases by on each time.

eg

='E:\Nick PhD\Nick Data\Parotec\kane Testing\Final tests\RacB\Speed test (kph)\[01.xls]Summary'!$D$6

then

='E:\Nick PhD\Nick Data\Parotec\kane Testing\Final tests\RacB\Speed test (kph)\[02.xls]Summary'!$D$6

then

='E:\Nick PhD\Nick Data\Parotec\kane Testing\Final tests\RacB\Speed test (kph)\[03.xls]Summary'!$D$6

etc etc etc. is there a way to do this of shall i carry on with typing all teh file numebr sin??

cheers