I have a list of names in cells B5:B14 on Sheet1
Each name in B5:B14 has it's own tab that is the same name listed in B5, B6 and so forth
Then on each tab for the names, in cell M10 I have a value
What I need to do is create a formula on Sheet1 that looks at the name in B5, goes to the tab, pulls cell M10, and puts that value in C5
Example
Cell B5 on Sheet1 = John Smith
Cell M10 on John Smith is 100
I need --> a formula in cell C5 on Sheet1 to show 100
I know this can be done with CONCATENATE somehow, I just can't seem to get it to work