Sage Intelligence Link Formula between Excel worksheets

Does any know if we can link (or reference) GL accounts from one worksheet to another in SMI report?  The purpose is to is to simplify update of accounts

Say sheet1 we have a good report.  In sheet2 column A, we want to link to accounts in sheet1.  
If works perfectly fine if we reference a single cell =Sheet1!A6
However, if we are to reference multiple cells, I get an error, say   =Sheet1!A6 + =Sheet1!A7

any one got a solution?  Thanks

Oh, i am using Sage 100 v5