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
Bookmarks