Break links within one cell but not all the links...

Hello, I have a workbook that is linked to 8 different other workbooks. There are many cells within the multiple tabs in this workbook that are linked to these 8 various workbooks and I want to break 6 of them while keeping the remaining 2 each each corresponding cell that originally had the 8 (or sometimes it is just 6, etc.).
so for example:

Currently have something similar to this in hundreds of cells within one workbook:
='[workbook1]sheet1'!AA15+'[workbook2]sheet2'!AA15+'[workbook3]sheet3'!AA15+'[workbook4]sheet4'!AA15+'[workbook5]sheet5'!AA15+'[workbook6]sheet6'!AA15+'[workbook7]sheet7'!AA15+'[workbook8]sheet8'!AA15

Need to have:
= 500++'[workbook6]sheet6'!AA15+'[workbook7]sheet7'!AA15+'[workbook8]sheet8'!AA15
Where 500 equals the value of the 1st 6 workbooks (not always in this order by the way) = '[workbook1]sheet1'!AA15+'[workbook2]sheet2'!AA15+'[workbook3]sheet3'!AA15+'[workbook4]sheet4'!AA15+'[workbook5]sheet5'!AA15+'[workbook6]sheet6'!AA15

Is there anyway to do this aside from manually going into each individual cell and adjusting it?

Thanks!
Kyrsten

It does still have that capability, but what happens is that it makes the entire cell be that value instead of just the 6 links I want as values and keep the remaining 2 links as links...??? I don't want the entire cell as a value - just part of it. Is there a way to do this?

As soon as I posted in another forum I received a response. Until I did this there was no activity (responses, there were views) which is why I did that. How else do you recommend I get a response?

Just thought I would post a work around that my colleague helped figure out - if you create copies of your tabs and then paste values on one tab, then only keep the 2 links on the other tab, then have a variance tab of the 1st two copies, you can paste value add the variance tab values to the tab with the 2 links left and this gives the same result. This is a work around for anyone that is following this posting and wants a result. Thank you for all your input everyone!