I just tried my 'simplistic' method that I set forth earlier. It seems to work.

I opened a new workbook and added 5 tabs. In tab 3 I added a series of 1's to equal 3. In tab 5 I followed my earlier stated procedure resulting in a total of 3. In that cell it showed a formula of: =1*Sheet_3!H11.

Is there a reason not to use my 'easy' method?

Mark