transferring total sheet from one workbook to another

[Daver10000]

I have a workbook with 5 sheets and a total sheet for those 5 other sheets
titled "Access". We have about 20 other workbooks that this total sheet needs
to be transferred over to to run totals. When we try to copy and paste the
total sheet into the 20 other workbooks, the total sheet referrences back to
the workbook we copied it from and will not total the other workbooks. Have
tried special paste, cut, copy, move sheet, copy sheet...nothing. Any ideas
how to more the total sheet(with formulas and cell referrences) from one
workbook to another without having it referrence back to the workbook it was
copied from? All workbooks have the same sheet names(sheet1, sheet2, etc).
Excel 2003.

 

[driller]

1. assuming that the 20 workbooks has 5 sheets each with similar tab name.
e.g. sheet1,sheet2,...sheet5.
2. assuming that the 20 workbooks are not shared.
2. the workbook named "Access" has one sheet for totalling the 5 sheets.

try this..

open Access workbook : 5 sheets and 1 total sheet
open Workbook2... 5 sheets
arrange window horizontally for viewing.

right-click the Tab name on the access workbook
click move or copy>To Book >select "Workbook_2" >chk. create a copy.

on Workbook_2,
Edit>Links>change source>browse for file/address of Workbook_2
enter.

your total must be updated based on the contents of sheet1 to 5.

 

[Daver10000]

You assumed close enough for me to figure this out. You are the best!! Can I
send you some $$? Hehehe. Thanks a lot!

 

[driller]

oppss...Santa is here !HoHoHo
happy holidays

You assumed close enough for me to figure this out. You are the best!! Can I
send you some $$? Hehehe. Thanks a lot!