auto fill names from 1 wrksht to another based on team #

[woodlawn75]

I am working on creating worksheets for a Calcutta Tennis Tournament. The first sheet contains the team #, team players and their handicaps; each with its own field. I want to be able to auto fill based on the team #. For example: Team 15, J. Gibson, handicap 4 and C. Black, handicap -2 is in worksheet 1. On that same worksheet I want to autofill which team plays which by entering the team #. Automatically the team players names and handicaps will be filled in. For ex. Team 15 vs Team 23.