Hi Paul

Run this macro one time
http://www.rondebruin.nl/summary.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Paul Sheppard" wrote in message
news:Paul.Sheppard.1t4kqt_1122966326.4131@excelfor um-nospam.com...

I have a workbook (Excel2000) with 130+ worksheets, I want to create a
Master worksheet with a link to cell A1 of each worksheet in column A
of the master worksheet

eg. in the the master cell A1 is linked to cell A1 Sheet1, A2 is linked
to cell A1 Sheet2 etc

Is there a quick way to do this or do I have to create each link
separately

Thanks

Paul


--
Paul Sheppard
------------------------------------------------------------------------
Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783
View this thread: http://www.excelforum.com/showthread...hreadid=392061