For each loops and Offsets

I am developing a code in VBA and I am having trouble with a task that searches a range in one worksheet for a string; then records the string in the same row but left one column (so .offset(0, -1)) for all occurrences; then it searches for each recorded string in another worksheet and sums the integers corresponding to the recorded strings to the right of the column.