Copying Data Between Sheets

I have two spreadsheets in the same workbook.
Sheet1 contains statistics for teams and years.
Sheet2 contains a listing of the teams in different orders.

How can I have excel copy a teams stats from Sheet1 to Sheet2 as it goes down the row? For example, A1 is atlanta 1996 so it copies a section of atlanta's 1996 stats to a specific range. Then A2 is detroit 2002 so it copies detroit's 2002 stats, and so on and so forth all the way down the list?

I am a beginner with VBA but I have experience with C/C++. I am just not sure of the functions for excel do all these things automatically and am having trouble finding applicable examples.

Thanks!