You can do it like this in D10 on mainpage sheet:

=INDIRECT("'"&C7&"'!H11")

Note the apostrophe between the double quotes and before the ! - these
cater for your sheet names having spaces.

Hope this helps.

Pete

On Feb 5, 12:44*pm, Atishoo wrote:
I want to return the contents of a cell on a seperate worksheet refered to by
name in another cell:

so if cell c7 ="policy"

and I want cell mainpage!D10 to return the value in Policy!H11

or if cell c7 ="calls"

then I want cell mainpage!D10 to return the value in calls!H11

any ideas?