Hi all,

I need some help with the following problem I am encountering.

In column a of sheet1, I have the names of sheets 2 to sheet 20.

In column b of sheet1, I want the contents of cell a200 from the sheets specified in column a.

Is there a formula I can use which will get the required data, or will I have to obtain this manually?