OK, I understand this:
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

...but
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)
Controls on a worksheet are not IN cells, but on the layer above.
As such column/row has little meaning regarding the control. You can access
them through the OLEObjects collections (amongst other collections).

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

...but
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
How does this relate to the "24 Labels & 24 Text Boxes" on each sheet ?

If you are using labels and TextBoxes, it may be easier not to. Just use
cells that you can then copy/paste etc.

NickHK

"Akash" wrote in message
ups.com...
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