How do I reference data from a sheet specified by text in a cell

R

RedWolf

I am trying to use the text generated in a certian cell as part of a function
which will reference the appropriate sheet and pull information from a
certian row.
 
Top