Hi all,

I have an excel sheet with is too lengthy. It has around 100 worksheets. All the worksheets have same kind of Column Names but the Values Differ.

I want to read couple of cell Values only from each worksheet and then store in it another Excel sheet.

I am able to count the Worksheets and as well as get their Sheet Name. But I am unable to search for my Cell Name and read it's value. Can you Please help.