Tab reference

[graham007]

I am trying to use a cell in my current worksheet to reference another worksheet in the same work book.
i tried using =b3!m15 but then it looks for a file called b3. i want it to reference cell m15 on the tab called "XXXX" where "XXXX" is the content of cell b3.

any ideas?

thanks in advance

[StephenR]

Here's an idea:

=INDIRECT(B3&"!M15")

[graham007]

perfect!!
thanks a bunch!