Matching or merging columns from one sheet to another based on standardized number

I'm working through some data in which I have the following:
Sheet 1 Contains a column of group names (in Column A) where each row has several columns of information attached to each group name (Columns C-F). Each of those group names has an individual standardized code attached (Column B).
In Sheet 2 I have the same group names from Column A from Sheet 1 spread through Columns A-E, each has a corresponding column that tags the standardized number to each of the group names.

I need to merge the Several columns of information that attaches to the group names and standardized number from Sheet 1 to the standardized numbers (across multiple columns, or one at a time) in Sheet 2.

There are thousands of entries, so I'd like to avoid doing it manually. Oddly this is something I've come to need several times, some people have recommended VLookup and I've done a lot of looking around the forums to see if this is possible in excel.

Any suggestions? I can provide some screen shots or more details if that's useful.