Accumulating Data From Sheets and preparing one summary sheet.
 

Hi

I have a Worksheet with 100 Sheets

In 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

No what 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.0
2 WXY DEF USA 1.2
3 ZWX GHI Canada 1.3


I want to accumulate all the data all the sheet present in the entire
worksheet.

How to do that.

Thanks

Akash