Pulling a value from another worksheet based on worksheet name in a cell

[Jay19]

Hi all

I'm trying to pull the value in cell J62 of another worksheet. The worksheet name is in B40 of the same worksheet where I have my formula. Essentially I am trying to pull the worksheet name and add it to the cell number to create a formula that pulls that value in another sheet. Here's the formula I'm trying but its not working:

=CELL("contents","'"&"B40"&"'!"&$J$62))

B40 contains the workbook name: "Fox Trails"

So I want the formula to evaluate as
=CELL("contents",'Fox Trails'!$J$62)
and return the value I have listed in J62 of the Fox Trails worksheet.

I don't have to use the cell function, I just thought that was easiest. I also tried
="'"&B40&"'!"&"$J$62"
but that just gives me the text 'Fox Trails'!$J$62

<tbody>
</tbody>

Thanks

 

[Jonmo1]

Put that inside INDIRECT

=INDIRECT("'"&B40&"'!"&"$J$62")


And actually, it's a little overboard with the concatenation...
Could be just
=INDIRECT("'"&B40&"'!$J$62")

 

[Jay19]

Put that inside INDIRECT

=INDIRECT("'"&B40&"'!"&"$J$62")


And actually, it's a little overboard with the concatenation...
Could be just
=INDIRECT("'"&B40&"'!$J$62")

Thanks for this. Worked like a charm

 

[Jonmo1]

Glad to help, thanks for the feedback.