Confused and bewildered

Hi,

I'm struggling a little bit.

I'm trying to create a new template worksheet that i can insert into any workbook.

I would like this worksheet to add the contents of cells in the workbook - although some of the totlas will be created by adding two or more cells spanning several workshhets. I thought i had this formula cracked (=SUM(SoR Data!$E$19) )but once i tried to simply copy the cell and its contents into an existing workbook it didn't work.

I know the names of the worksheets that i want to check and use to create my total and i know the cell that i want to use. Should i be able to use the formula above and excel will recognise the worksheets name?

Am i going about this the wrong way? Should i try to incorperate the formula into VB code? How do i do that?

As you can see i'm toying with several ideas.
Any help would be appreciated.

Thanks in advance.

Paul