I have 15 individual trackers that contain names (A1 -A700) and then data for
those individuals in B1-E700. I want to pull the data from B1-E700 if present
to a master tracker. Tricky part is the location and place on the individual
trackers may vary month to month. Can I have a formula that will search for
the name amonst all trackers and pull the data if present to the master
tracker? Please help I am going insane.