Weekly Timesheet Worksheets reading into Gross

Hi
Brand new to this site so pelase bear with me if I waffle!
I have a workbook with 6 worksheets. 5 represent weekly hours and the final one being the accumulation of each 5 - called Gross.
The worksheets consist of employees allocated to sites and are written in the order of client sites. As they have a budget per site, I need the order to remain consistent throughout to the Gross
So if an entry is added i.e. new employee to site; on Week 1 I need the same name and code auto entered on subsequent worksheets but NOT the hours.
By using the Group Worksheet I can have the lines inserted and I have also worked out how to the data replicated. But as explained need the text only really as the hours are inout each week as relevant.
Any ideas?
Also interested in knowing if I can ensure that if lines are inserted that formulas in the above row but only in certain columns copy down?