Not getting the total from another sheet after hyperlink is read because of multiple hyperlinks

Not getting the total from another sheet after hyperlink is read because
of multiple hyperlinks

References

Reference NO 1

http://stackoverflow.com/questions/15189540/not-getting-the-total-from-another-sheet-after-hyperlink-is-read-because-of-mult

Reference NO 2

http://stackoverflow.com/questions/10130040/automatically-creating-hyperlink-to-another-sheet-by-text

Reference NO 3

http://stackoverflow.com/questions/6846958/optimized-way-of-adding-multiple-hyperlinks-in-excel-file-with-c-sharp

Reference NO 4

http://en.wikipedia.org/wiki/September_11_attacks

Reference NO 5

http://www.cdc.gov/vaccinesafety/vaccines/HPV/Index.html

Reference NO 6

http://www.nrc.gov/reading-rm/doc-collections/fact-sheets/bio-effects-radiation.html

Reference NO 7

#EANF#

Reference NO 8

#EANF#