I have a excel work book with worksheets which named as 1, 2, 3 Up to 100 and a summary sheet.
Each and every sheet includes a name in cell C2. I want to have each name of every sheet to the summary sheet in column B on after the other row by row.
For example In Cell B2 – Name of the Sheet 1
Cell B3 –Name of the sheet 2
Can you tell me a easiest way to do this.