I have a workbook with multiple sheets. The first sheet is "Master List" with Column A populated with "Player #" then columns B,C,D,E, F, G, H with other data like address phone number email etc.

What I want to do is to be able to make a new sheet that auto populates the data from the Master List columns B,C,D,E, F, G, H into the new worksheet with just the input of the Player Number in Column A of the new sheet.

So I want the new sheet to look at the input of the player number in Column A, then reference back to the Master List sheet A, find that number then auto populate the blocks B,C,D,E, F, G, H with that same data.

Hope that all makes sense???

Rich