I have a workbook of sheets containeing Titles in a4 to i4 and its Values in
a5 to i5. I need to drag the a5 to i5 of all the sheets (1,2,3,4...200)to a
"Index" sheet to make the Summery. Cell a1 to a5 is having same titeles of
all the sheets. In the "Index" sheet, a5 of the sheet '1' will be in a2 and
a5 of the sheet '2' will be in a3 if I drag. I do not know what is the right
formula?