Ginger,
Create a dynamic named range!
Press Ctrl+F3 to get to the named range manager.
Then paste the following in the formula box
=OFFSET(Sheet1!$B$3,,MATCH(Sheet1!$A$1,Sheet1!$C$3:$L$3,0),1,MATCH(Sheet1!$A$2,Sheet1!$C$3:$L$3,0)-MATCH(Sheet1!$A$1,Sheet1!$C$3:$L$3,0)+1)
Make sure you name...