ok- here's what I'm trying to do

I have a bunch of sports teams and their stats, and I want to be able to quickly compare stats from different teams

Each team has their own sheet, organized like this

Attachment 212663

I then have a comparison sheet, organized like this

Attachment 212664

I want to be able to type in team names in cells B,1 and E,1 then hit the Import button and have it fill in the stats in cells B,4:B,6 and E,4:E,6

So, the macro must use the value of cell B,1 or E,1 to determine which sheet to pull data from

Any suggestions?