Macro to link to another workbook

[shredda23]

Hi guys, I am fairly new to VBA but I'm hoping someone can help me. I will try to explain what I need the code to do. I am an accountant and my main file that I am working on has a list of properties with their respective market values in the adjacent column as an example. The total at the bottom of this list must match the total in another workbook. So I need the macro to find the value in the other workbook and link it to my main workbook so I can see if there is a difference. The problem with me just doing it manually is that when someone adds a column in the other workbook, the link does not update itself so my main workbook links to the wrong cell after someone adds columns to the linked file. So the macro needs to the find the value in the other workbook, the link will always be offset one the right of the word "CJV subtotals". I have about 40 different links I need to add to around 8 different workbooks. If I see how one link works I could alter the code for the other links. Any suggestions are welcome. Thanks

 

[shredda23]

Maybe I have made this too complicated. Is it possible to perform a find function on another workbook to copy and paste a total to the current workbook I would be working on?
So the macro would say find total gross market value for a list of properties and then paste it in the workbook I am working on.