I have several workbooks to maintain and I want to be able to gather
information from all of them and filter them by different criteria. For
example, searching through all the workbooks, display only the rows that
contain the word "Item".

Is this possible? and How?