Sheet Reference

I am trying to create a summary sheet in excel 2007 that will reference cell numbers in various sheets without having to type the sheet name in. For instance, if the sheet 2 is Johnson, AZ and cell a1 is “Marketing Location”, I would like to have it automatically populate that cell with Marketing Location. I would then like to drag that formula down so that it will list the next location. For instance if the formula was =(sheet2!,A1) then the next would be =(sheet3!,A1) etc.

Your assistance is appreciated.