I have 2 spreadsheets (2012 and 2011) with 5 columns each (week #, warehouse id, item number, item description, On hand dollars). What I would like to see is if a can have some kind of macros in a different spreadsheet that would let me pull just by typing the week number a comparison of on hand dollars from 2011 and 2012.

I have 52 weeks
I have 5 warehouse numbers
About 1700 items, descriptions each with a on hand dollar value for that specific week

I want to be able to compare right away my numbers for 2011 and 2012 by just looking at x week or by just typing a week number and the system be able to bring up the items abpve for that specific week.