Hi all,

Just wondering if it's possible to do the follwoing using functions or I
need to use VBA:
SEARCH all the THE TABS in the active Workbook THAT CONTAINS A CERTAIN
TEXT/NUMBERS AND RETREIVE DATA FROM A CERTAIN CELL IN THAT SHEET?

Thanks in advance