I have an excel sheet which has around 25 tabs. There is a master sheet which has names of all employees in our system. I have to use the employee name from this master sheet and search for occurrence of this name in any of the other sheets. If any occurrence is found, I need to have the sum of salary in those excel tabs corresponding to the employee name displayed in my master sheet.
For example, I have Employee Name John in my master sheet. If John appears in sheet 5, 6 and 10. I need to find the value of salary in those 3 excel tabs corresponding to John and then display in my main tab the sum of all salary for John.
Thanks for any help.