This should help you out:
http://www.rondebruin.nl/tips.htm

Pay attention to the section titled "Copy/Paste/Merge examples".
Your explanation sounds a little confusing to me, but I know you know what
you want; you should find it in that web link above.


Regards,
Ryan---

--
RyGuy


"akfrumtarn" wrote:

I have a master spreadsheet with hyperlinks to around 2,000 other
spreadsheets. All of the hyperlinks are held in the same column. All of the
other spreadsheets are of a standard format. There are 8 cells on each of
these spreadsheets that contain data that I want to collate in the master
spreadsheet. How do I do this without resorting to manually linking to all
2,000 sheets?
--
Thanks in advance of your replies. Your help much appreciated