Excel 2007 : How to generate a new record in new row on multiple work sheets

Hi,

I am trying to merge several Excel 2007 workbooks into one workbook as linked sheets so that they may all work together automatically, rather than having to manually enter the data into each. Here is what I have:

This workbook contains the following worksheets:
• Budget summary
• Budget daily
• Employees
• Employees profile
• Project schedule
• Timesheet

I am looking to achieve the following:

1. When a name is entered into the ‘Budget Daily’ sheet, have it generate a new record in ‘employee’, ‘Employee Profile’, and ‘project schedule’ sheets as well (the detailed employee information can be added manually afterward in ‘employee profile’). A problem I am facing is I have copied the cells from ‘budget daily’, and used paste special to enter them into the ‘employee’ sheet’, however when the fields are full and a new row must be added under one of the headings (i.e. there are four Project Geologists on a job) it does not automatically update in ‘employees’.


Thanks very much for your input,

Colins

Hi colins
Zip up the workbook and I can have a look

I have altered the original file attached to this post in an effort to help clarify my question. I have linked a persons name, for instance, to several sheets using copy>paste special. However, when a new employee needs to be added in say the Project Geologist heading on the budget sheet, I have to manually insert a new row in each of the other sheets and copy>paste special to link the new field. Is there an alternative to, or a different setting in paste special, which could create a dynamic link between the records? This way when a new record is needed and new row is inserted, all of the corresponding pages will display the changes as well? If not, perhaps an 'insert new row' using scripting?