I wonder why you need each location displayed on a seperate sheet, but you can use the VLOOKUP function.

Either move the Location column so it is the first column, or make a formula to display the Location in the first column.
In each of the other sheets, put a location in A1.
Group the 54 Location sheets and use this formula in cell B2 (I assumed the data was on Sheet1, A1:H22000):
=VLOOKUP($A$1,Sheet1!$A$1:$H$22000,2,0)
copy across however many columns you have, but each time change the 2 (the third argument) to the next number (3, then 4, then 5, etc)
Ungroup the sheets.