Matchin columns in another sheet

Hello,

I have a document with several worksheets. One is meant to be a total count, encompassing all the others.

I need to know how to get the total sheet to automatically populate the values listed in the corresponding columns on the other pages. I tried to just do = corresponding column in the page, but issues occur when the pages are sorted differently. I also tried vlook up but because cant get that to work either.

In essence, I need a formula that will look up a name in column a find that name on sheet 2, and return the info listed in column b for that name.

Please help.