Retrieving data from same cell from a list of worksheet names

[TMAZZ]

[TABLE="width: 331"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD]Not sure what I'm doing work but I'm having problems retrieving data from the same cell from many worksheets.

The formula is returning an error can you help me? Please[TABLE="width: 64"]
<tbody>[TR]
[TD="class: xl65, width: 64"]=INDIRECT(""&B20&"'!J6)[/TD]
[/TR]
</tbody>[/TABLE]


This column lists all worksheets ie.
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]'=INDEX(sheetlist,ROW())[/TD]
[TD]SAM[/TD]
[TD]'INDIRECT("'"&A20&"'!J6)[/TD]
[/TR]
[TR]
[TD]JOHN[/TD]
[TD][/TD]
[TD]5%[/TD]
[/TR]
[TR]
[TD]DAVID[/TD]
[TD][/TD]
[TD]3%[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
I want the third column to look at Column A Row 20 which reads worksheet name SAM and in that worksheet drop the data from cell# J6,
This is repeated as many worksheet exist so the next worksheet name is John and in that worksheet cell# J6 is 5% and so on

 

[Momentman]

Never mind I got it to work thanks

Glad you got it working, so would you mind sharing what the problem was or what fix you used?