worksheet sorting and linking?

[greyhoundmark]

I have a report that changes monthly....I have a workbook that has 41 worksheets

i'm trying to have several different worksheets import information from a summary worksheet that has all the master data on it.

I want the worksheets to sort by a location field (ie: ABC, XYZ) then pull all the data from the summary worksheet for that location.

The sheet has 9 columns (A=text column, b=date column, c=time, d=number, e=$value, f=location field, g=$value, h=text, i=text

any ideas?

Thanks for the help in advance!