I know a thread for the information I need exists somewhere buy I can not for the life of me find it.

Is it possible to use the index/match function for an entire external workbook? For example, I want to lookup a cell from "Sheet 1- Workbook 1" throughout multiple sheets in an entirely different workbook "Sheets 1-10 Workbook 2" and return a corresponding value from Workbook 2.

Any help on this would be much appreciated.