Try this macro that create links to the cells
http://www.rondebruin.nl/summary.htm


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


"deb" wrote in message ...
I have many titled worksheets in one workbook. I want to copy cell a10 and
cell J10 from each worksheet to a new worksheet in the same workbook so
column a lists all the cell a10 data and Column B lists all the cell J10
data. Each worksheet has its own name.
What's the easiest way to accomplish this?
Thanks.