Use of Hyperlink in a formula?

Hi, hoping someone can help? I have staff training results on individual worksheets, i am trying to take the training completed to fill a spreadsheet on another workbook and mark "X" in the corresponding column?

I thought i might have been able to use hyperlinks to make it more simple?

Any help would be great

I am hoping to link staff names from one spreadsheet to another while searching for training criteria... So spreadsheets named 'John'! 'James'!, 'Jane'! etc to link to 'training level 1'
So data on the sheets with names I will be looking at one column of data 'James!$B:$B, names of training courses.

I would like to to get 'Training level 1!' Cell A2= "James" to lookup the sheet 'James'! While searching for the name of the training course in the cell B1. And place an X if it finds the result.

I can get it to work =if(vlookup(B1,James!$B:$B,1,False)" ","X")

I have 100 staff and I thought having to enter the sheet name in manually would take to long so would like to find a simpler way?

Hi thanks for that, that seems like a simple solution... how ever i am getting an error on that formula? Is there something i could be doing wrong? It is not picking up the reference text?

=if(isnumber(match(e11, indirect(j21 & "!$b:$b), 0)), "x", "")

I will try again:

=IF(ISNUMBER(MATCH(E11,INDIRECT(J21&"!$B:$B),0)),"X","")

E11 = Training name
J21 = Staff Name/ Sheet Name
Column B = Training names

I will try again:

=IF(ISNUMBER(MATCH(E11,INDIRECT(J21&"!$B:$B),0)),"X","")

E11 = Training name
J21 = Staff Name/ Sheet Name
Column B = Training names

No spaces it just has the staff members first name.. but thanks for that i will be adding last names when i get it working.. the error is highlighting the "X" part of the formula? if that helps you with where its going wrong for me?