I've got an excel workbook that I essentially need is something that will look across multiple worksheets within the workbook and report a value that is a particular cell.
So, if in Sheet1, cell B4 is ABC123, it will search all other worksheets finding this number (call this "SheetX" that it finds), and then in B3 in "Sheet1", enter the figure from "SheetX" that is in T2.
Is there a solution for this? I've tried searching but couldn't find anything that I could use to make work. Or am I on drugs trying to do this??