I need to search multiple sheets like this for certain words like
#hobbies and add up the numbers on the adjacent column.
In this sheet, I need to add up the values in "Sheet 2" and "Sheet 3", for the cells in column B adjacent to the words
#hobbies. After I add them up, I want to put the total for
#hobbies in the cell adjacent to
#hobbies in "Sheet 1".
Essentially I want to assign
"Sheet 1!B1"="Sheet 2!B1"+"Sheet 3!B3"
"Sheet 1!B4"="Sheet 2!B4"+"Sheet 3!B9"
Since I don’t know the location of these words,
#hobbies a priori, I need to search in column A, and find out the values and then add them up.
What code or function will help me evaluate this and do this job?