How to use sheet name in Vlookup using user input

I'm a complete newbie at the entire VBA/Macro world, but what I'd like to do is this:

I have a workbook with about 60 sheets in it, more to be added, each sheet with a unique character name. I would like to be able to, on the first worksheet, enter the name of the character, and have it do a vlookup on the character stats on that character's worksheet. Is this at all possible?

The code I have right now looks something like this:

Please Login or Register  to view this content.

But that obviously doesn't work.

Any help would be greatly appreciated.