this is a tricky one

ok here is my dilemma i have a master sheet that contains huge amounts of data pertaining to media and stations across the country. i would like to buid a formula that would search out specific stations and their stats each time it runs or each time i upload the master sheet from our agent. i think an array would have to be in the solutions somewhere.. i have attached a sample file to show what i am working with. instead of a "sumproduct" function i would need to show each individual airing of the station....... i dont think each formula could be the same or it would pull the same data over and over again. so here is the question.... given the sheet attached how can i have the corresponding sheets search through the master and pull each row of stats that = that specific station???? email me at cjohnsen@nmrdirect.com if you need more info.

thanks so much in advance for everything!

c