Hi guys,

I've been looking through the past discussions but could not find the answer
to my problem.

I have a document with several worksheets.
There are individual wkshts organized by location. They have the
location/professor and all the other info in them.

Then there are two summary wkshts, 1 organized by location, the other by
professor.


I am looking for the easiest way to keep the summary pages updated
automatically and right now,
I have a vlookup function on the wksht organized by professor.

Is there any way for me to be able to input a formula that would
allow me to search multiple worksheets for a text value "professor name"
and input the corresponding location and etc. under it?

Thanks guys