Look up Formulas with Results
 

I need to know how to write a formula were it searches the numerous sheets
for a specific cell reference and is able to copy all the information in the
column matching the specific cell requirements on the one sheet. For instance
I am searching for "DM" on all the sheets and if it has a cell that has "DM"
in it I want to return all the information in that column back to the summary
sheet. Thank you for your time and assistance. Hope this question makes
sence.