Search for string, copy adjacent cell

Here is the brief summary of the problem I've run into, and am hoping one of the gurus here can hlep with.

I am working with workbook Rollup, which has an area to display a total cost generated on multiple cells and multiple spreadsheets from workbook Costs.
What I am trying to do is write a function in a cell in the main spreadsheet of workbook Rollup, that will do a search for the word "Diff" in all of the spreadsheets in workbook Costs and then aquire the data from the cell to the right of the "Diff" cell, and total them all together in the cell in Rollup.

The problem is, the number of items before the "Diff" cell changes, so "Diff" is not always located in the same row number which has put it outside of my Excel skills.

Not sure how to make that any more clear...sorry.

Originally Posted by GeneralDisarray

Can you post an example? You would likely be able to work without VBA using some intelligent formulas in the worksheet. There are VBA trick to do this also - either way, without an example it's hard to help

Here is a mockup of the workbook I need to pull data from. As you can see, the cell "Diff" is in a different row for each spreadsheet due to the number of items.
I need to pull the numbers from the cell to the right of "Diff" on all of the spreadsheets in that workbook and total them up in a cell in a different workbook.

Book1.xlsx

I'm not very strong with VB. This code works like a dream in the example file. I will be using it in work book "Rollup", to execute its job in regards to data in workbook "Costs"

Originally Posted by omaolain

I'm not very strong with VB. This code works like a dream in the example file. I will be using it in work book "Rollup", to execute its job in regards to data in workbook "Costs"

Any guidance on how to adjust the code to work and place the total value in spreadsheet Rollup, but aquire all of the data it is searching for from spreadsheet Costs?

The data will be collected and pulled from all the spreadsheets in the workbook "Costs" (the code you wrote works wonderfully for that), and needs to be delivered in workbook "Rollup" which is the part I'm struggling with.
I can follow some of it, but VB is most definitely not my strong suite.

Originally Posted by omaolain

The data will be collected and pulled from all the spreadsheets in the workbook "Costs" (the code you wrote works wonderfully for that), and needs to be delivered in workbook "Rollup" which is the part I'm struggling with.
I can follow some of it, but VB is most definitely not my strong suite.

Any further guidance on how to create this particular change?
I've played around with the code trying to make it work, but all I manage to do is take it from functioning to nonfunctioning.

GeneralDisarray,

Thnaks for your help with this, I actually got it working not long after my last post. Again, I really appreciate the help you gave me on this.