Loop through sheets - pick up formula from same cells each sheet into summary sheet

Originally Posted by ar2210

Hi All,

This is exactly what I want to do, but the only difference is instead of sheets named as 01,02 (i.e numbers), they are product names/text for eg. tea,coffee,milk etc.. And I want my summary sheet to get costs,NPV etc from other worksheets but same cells.

Can anyone suggest please.

Many Thanks in Advance.

Arpita

Thanks, Just worked it out!