My first worksheet is labeled Spirs 1 and the folowing sheets are labeled A CO, B CO, C CO, D CO, and HHC, all in the same workbook. I want to add the data from B2 on the worksheets and display the results in Spirs 1, B2. I have done all I know and every time I think I have it right it opens up a window looking for another spreadsheet to update the values in A CO, B CO, C CO, D CO, and HHC, I am not trying to update the values in another spreadsheet, just wanting to add the data from several worksheets and show the total in the first worksheet (Spirs 1). I also want to add B3 and B4 and then C2, C3, C4, then D, then E the same way. Please help.