I have approximately 30 worksheets in one workbook. I have one worksheet
called, "Search Template" where I want to be able to type in a word in a
particular cell (say, D6) and have Excel look through all the other
worksheets in the workbook and pull back the information about that word.
For example, if I type in the word LOAN on the "Search Template" worksheet in
cell D6, I want Excel to find the word LOAN in the other worksheets and pull
back the entire row(s) of information where that word, LOAN is found.