Hi

I have a Worksheet with 100 Sheets

All the Sheet is named as 1,2,3,4,5,6,7,8,9,10......100

All the Sheets is having same format.

All the Sheets i have Two Columns


B & D
Column B Labels
Column D Text Box


In Each Sheet we have 24 Labels & 24 Text Boxes (Column C = Labels &
Column D = Keying area)


Now I want is to develop a macro through which i can accumulate
data in one sheet named as Summary.


Which shows data as


Form No| Client Name / Company| Location | Version


1 XYZ ABC India 1.1
2 WXY DEF USA 1.2
3 ZWX GHI Canada 1.3


I want to accumulate all the data of Sheet 1 to Sheet 100 present in
the entire
worksheet into a new Sheet Summary in the same workbook.


How to do that. I am in desperate need of this. awaiting for a
solution to this problem.


Thanks

Akash