Hello all, I've been posting my question a few times with no responses, and so I keep on trying and trying to make this work...
Now, I have the following vlookup formula:

=VLOOKUP(+'sun non TA 1'!C6+'sun non TA 2'!C6+'sun non TA 3'!C6+'sun non TA 4'!C6+'sun non TA 5'!C6+'sun non TA 8'!C6+'sun non TA 9'!C6+'sun TA rates 10'!C6+'sun TA rates 9'!C6+'sun TA rates 8'!C6+'sun TA rates 7'!C6+'sun TA rates 6'!C6+'sun TA rates 5'!C6+'sun TA rates 4'!C6+'sun TA rates'!C6+'sun TA rates 2'!C6+'sun TA SUPV'!C6+'sun TA SUPV (nights)'!C6+'sun TA SUPPORT'!C6+'sun TA D LABOUR'!C6+'sun TA D LABOUR (nights)'!C6+'sun TA IND LABOUR'!C6+'sun TA IND LABOUR (nights)'!C6+'Shell Job2'!C6+'Shell Job3'!C6+'Shell Job4'!C6+'sun non TA 14'!C6+'Shell job6'!C6+'Waterville 1'!C6+'Waterville 2'!C6+'Waterville 3'!C6+'Waterville 4'!C6+'Waterville 5'!C6+'Waterville 6'!C6+'Shell job5'!C6+'curran rate'!C6+'sun non TA 15'!C6+'sun non TA 16'!C6+'sun TA rates 1'!C6+'sun non TA 17'!C6+'sun TA rates 3'!C6+'sun non TA 18'!C6+'shell job1'!C6+'sun non TA 10'!C6+'curran @ IOL rates'!C6+'sun non TA 11'!C6+'sun non TA 12'!C6+'sun non TA 6'!C6+'sun non TA 7'!C6+'sun non TA 13'!C6+'2012'!C6+'Contract 1 (9)'!C6+'Contract 1 (10)'!C6+'Contract 1 (11)'!C6+'Contract 1 (12)'!C6+'Contract 1 (13)'!C6+'Contract 1 (14)'!C6,[NAME],1,FALSE)

which results in #N/A

but the n/a only displays where there should be the addition of (like if the formula was working the addition would be there... but it instead shows #N/A only in the spots where i've put some test data)... so i know it is working, but it is not adding up all the "C6" values together!!

so close yet so far!