How to use INDIRECT and XLOOKUP in a formula in order to fetch a value from DIFFERENT work

In the main WS I want to use the list of WS names in C3:C6 to find the correct numbers in AR3:AR6
So hatever name I am keying in B11, the correct path is worked out, and the values in that particular WS is shown in C11.

Se attached WB

B5 is the lookup value (Barbare Gordon)
B3:B6 is the search cloumn (Potatoes)
C3:C6 is the name of the WS (Potatoes!)
AR3:AR6 is the range in any of those WS's where the wanted values lies.
So ... when cell B11 in the main WS contains a tekst string, I want to go to a certain one of those other WS and fetch the correct value from that WS's AR3:All

I tried almost everything, but not the correct method it seems.
All combinations with the use of qoutationmarks and ampersands, I guess ...
Nothing works, so far.

Anyone have an idea of what I'm doing wrong?

Use this formula in D12:

=INDIRECT("'"&VLOOKUP($B11,$B$3:$C$6,2,0)&"'!AR"&COLUMNS($A:D)-1)

copy across into E12:G12.

You may need to use semicolons ( ; ) instead of commas ( , ) in the formulae.

Hope this helps.

Pete

Thank you guys ...
With your help I managed to get it to work, and customize the formula completely to my needs.