options required for finding/checking data from a list in multiple workbooks

options required for finding/checking data from a list in multiple workbooks

I have a list of data in one workbook that needs to be crosschecked in
multiple workbooks to see if the same data appears eg a company name
appears in workbook. how can i do this? excel 2003 I usually visually
check each workbook page by page for over twenty different companies. I
know I can use find but i have multiple values to look up/find in multiple
sheets and in multiple workbooks