Copying worksheets into a new workbook changes information on shee
 

I have a 2003 workbook that has multiple worksheets in it. Once the first
worksheet is filled out, it populates fields on the other 5 worksheets. This
workbook is a template. Each file(workbook) is a different client. One of
the sheets, lets say sheet 4, needs to be copied from each of these workbooks
into a single workbook for reporting purposes. I copy sheet 4 from workbook
1 into a new book. Then I go to workbook 2 to copy worksheet 4 into the new
book. The client name on sheet 1 changes to the client name on sheet 2. Now
I have 2 sheets with the same name and information, but it doesn't change any
of the calculated fields on each of the sheets. If I copy sheet 4 from
workbook 3, that client's name appears on the other two sheets, and so on.
Question, how do I copy these sheets without having it change the information
each time a new sheet is added? I have renamed each of the sheets in the
original workbook, but I guess since the info is still the same, it still
changes it. Help! I don't want to retype all the information on each of the
sheets in the new workbook! Thanks for any help.