I have 30 worksheet where all the employee name, salary number and overtime
have

Out put and result €¦€¦€¦€¦.. I want to make a master worksheet where I just
enter (in a cell) one employee salary number and it will display all the
employee overtime searching from all 30 worksheet. How? Only through a
formula can any one help me now?