combine multiple sheets, each sheet has info in different cells

[Guest]

I am in a football pool. Each week I send out a spread sheet with all of the
games listed across the top. Each person's name is located on the side. I
want to take each spread sheet that i recieve and combine them to a master
sheet. This will aleviat me from having to manually enter everyone's picks.

 

[Guest]

A trick to save lots of time is use the person's name on the worksheet tab.
So when you send Trevor his sheet it will have his name on the tab. When you
get the sheets back you can simply copy them into a single workbook.