I'm doing some home work for Excel '07. The excerise is using NFL data. I need to be able to enter data on one sheet and have it appear on another. Here's the excercise: I have a sheet for the 49ers which contains Individual Win -Loss records for coaches. The data has to come from another sheet for each individual coach. e.g. Bill Walsh 1988 10-6. The problem I'm running into is for 1989. George Seirfert sheet is 1989 14-2. I need to enter the info on each coaches sheet and have it automatically appear on the team sheet in order by year. How can I accomplish this? Also, I have already grouped the 49ers sheet with Bill Walsh's sheet.