Using Named Ranges across multiple worksheets to sum, Arrays

[jlario]

I have three country tabs. Each one has accounts in column A and Dates going across row 3. Is there a way to use a create a summary tab using a named range of the worksheets, accounts, and dates, so that if a new country is added all i need to do is update the named range of the worksheets and it will get addded into the total?