Index Data

[Utsav]

Hi Dear,

I have a list of I say about 50 sheets ,
In all my sheets G4 contains "Cust id " and C7& C8 contains name and address respectively.

would like to know Can some how I get, Cust Id, Name and address in a single sheet without copying or pasting.
Like

Cust Id Name add

thanx in advance. !

Regards,
Utsav

 

[Sektor]

No problem.

Change this line:

    For i = 1 To 50

to this one:

    For i = 1 To Sheets.Count

 

[Utsav]

u Rocks !
Благодарим U !! (Google Translate)

 

[Sektor]

Благодарим тебя! This will be more correct!