I have about 100 sheets in my workbook, and I want to create summary sheets which will take for example the cells A2, B4 and C6. It would then put this information in the summary sheet, each row representing a sheet.

Is there anyway to do so, without making the link one by one for each sheet?

Thanks a lot,

Cope