I have a number of Sheets that refer to different Locations say "Birmingham","London","Bristol". each of these sheets is formatted exactly the same with the same information but different values.

I have various formulas that pull the relevant information from one sheet to the front summary sheet, how can I make it so that when I drag the formulas across it represents a different sheets ie: column one is all the Birmingham values, column 2 is all the London values?

Thankyou in advance