Loop through all sheets and get cell value

[Zaeguzah]

Hi everyone. I would like to get the cell value in B2 from every sheet and place the results in a sheet called "index".

Something like below but without the formula. Just the value.

Please Login or Register  to view this content.

Thanks for your time and intent.
Alex

[antoka05]

You could use this macro:

Please Login or Register  to view this content.

Regards,
Antonio

[Zaeguzah]

Thanks Antoka and a big thanks to all helping users on this forum.
SOLVED!!