I need help with how best to link the following in excel:

I am trying to build a master file that is manually updated to include job
name (column 1), job number (column 2), person's function (column 3),
estimated fee for that function (column 4) and then broken out on a weekly
basis for April (columns 5, 6, 7, 8). We will have many different functions
for one given project, so there could be up to 10 rows. I then have a linked
spreadsheet file that rolls up the totals by department. So for example, my
linked file would show just 3 rows rolled up for the same project in which
you'd see 1 row for Client Management, 1 for Media and 1 for Creative.

Once I build the basic layouts, I then want to set up an automatic feature
to update the linked file whenever a new project has been inserted into the
master file. So if project B is added with the same 10 rows as what project
A had, then the linked file would also be updated to pull in the 3 rolled up
rows.

Does someone know how I can do this? I am proficient at the basics of excel
but have not used macros before. I used the demo on the MS Office website,
but it didn't go into that great of depth. Any help someone can provide
would be greatly appreciated.