Sounds easy - however I am looking for a formula which adds together the same
cell across identical worksheets that do not exist. Confused? Well - the
template I have set up allows the user to select a country and then run a
macro that creates a new worksheet for that country. These worksheets are
identical. Once they have selected all the necessary countries the "Total"
worksheet needs to have a formula which adds them all up. The problem is that
I can't have a normal formula in the Total sheet before the new countries
templates have been set up.

Any ideas?