I am creating a summary page for multi worksheets. Is ther a way to have a
cell mirror a row of info on the summary if a specific word appears in a
specific cell on the orginal worksheet?