xl2003

I need to build a summary table which will be full of references such as
=R1!E3.

My problem is that I have about 1200 existing workbooks that I need to paste
the table into.

And when I do it looks like =[12Sept05.xls]R1!E3. Is there any way I can
paste the ref. but without listing the original book.

So I want to copy =[12Sept05.xls]R1!E3 and then paste =R1!E3. The finished
table would have about 50 such refs.

Any help would be greatly appreciated.

Ta,
Martin