Copy paste a particular cell value from all Sheets to Index Sheet

Good Day All!!

I need little help in fetching the count value available in each sheet to the Index Sheet.

The workbook contains:
1. Index Sheet
2. Sheet-1, Sheet-2, Sheet-3 ....etc
3. Each sheet has the count of parameters in Column-N and Cell-N1
4. Index has the list of Sheet Names, Sheet Description and No of Parameters

Solution required:
a. Go to Sheet(i)
b. Copy Sheet(i).N1
c. In Index Sheet
x) search for Sheet(i).row
x) Paste Sheet(i).N1 to its respective count of parameters in Index Sheet

Please Login or Register  to view this content.

Kind Regards,
Sreeks

Try:

Please Login or Register  to view this content.

The sheet name for MMOD24AC has an extra space at the end of the name. Delete that extra space or the macro will not recognize it.

You are very welcome.