I have a wookbook containing approx 65 separate sheets. First sheet is a
summary page which i need to copy a value from each separate sheet. I can't
copy these using a fill series, and to do an individual link from each sheet
would take a while, so my question:
Is there a quick way to copy a link and fill down (where down means moving
to next worksheet).
ie.
summary sheet a1 = worksheet 1 cell b1
summary sheet a2 = worksheet 2 cell b1
summary sheet a3 = worksheet 3 cell b1

Many thanks in advance,

--
Jan