Excel looking up data on Sheet 2 and transferring common data to a separate sheet

In Sheet 2, Column B there is a list of names with rows of data. Those names will not change. Each name in Column B has a coresponding worksheet in the workbook. I want the program (Excel 2007) to copy the complete row of data for each name to the matching sheet. Can Excel 2007 do this?
--
Michael S. Romano
E-mail:[email protected]

Yes. See attached file.