insert/delete rows automatically to other worksheets when altering master list on sheet 1

Hello all. I've been reading and reviewing Forum posts and improving my Excel skills for a little while now. I would rate my skills as intermediate: I'm becoming pretty handy with formula use and formatting, but am now perhaps needing to get into macros (dreaded). Thank-you everyone for the advice provided and Forum creator for the service.

My challenge: I regularly need to add or delete a row (only 2 affected columns) to my master job codes list which I keep on sheet 1 in the workbook and have added a named reference for (JobList). I then have 14 subsequent pages for 2 weeks worth of days and on each one I breakdown the personnel, hours, and funds spent across the varying jobs, and these figures autosum in columns next to a copy of that same JobList. I then have an additional worksheet which breaks down the bi-weekly totals apportioned through again the same list.

All the jobs for this workbook (currently amounting +/-15 jobs) are within a plant for a single client. I need to present the departmental and individual job figures biweekly in a progress management meeting, so I endevour to have a neat professional excel file that is relatively dummy-proof for other supervisors to enter data into. As jobs may be completed, or others added, on any given day within any 14-day shift, I'd like to be able to make this change on the master list and the change then automatically reflect on the affected list portion of the other pages. Hopefully, when a new row would insert with a new job number and cost code (2 separate columns side by side in a chart appearance), the columns next to these would also automatically adopt the same calculation formulae using entered data on that sheet. (I protect all cells on the sheet save for a few simple data entry ones used by others, so as to preserve my formulas).

I set up the dynamic named reference for my list, as mentioned. I tried to use an OFFSET with COUNTA formula on the other sheets to populate the list info for me hoping it would add and subtract on those sheets according to master reference, but I could not seem to find success with this method. I would get a #value error whether trying with the OFFSET/COUNTA formula in a single cell - to fill to surrounding, and also when trying to highlight the entire range to use this formula. Maybe I'm using this feature incorrectly (I hope so, as I would prefer this means than needing resort to macro creation)

After much frustration, I have caved and began to accept that I may need to use a macro. I have zero experience with this, but do have confidence in my learning ability/aptitude. I've searched through this forum and around the net and cut/paste similar purposed macros. But none of this would work within the context of my workbook with its unique column widths and the the master list location on the first sheet (columns A and B) is different than on the subsequent sheets (columns H and I, with accompanying info next to in J and K). I tried to modify the macros to reference the cells I need, but the run failed each time for varying reported reasons. To avoid altering my entire sheet, I'd like if I could only have a row with these 4 cells inserted with the first two matching the 2 cells accordingly from the master list. The bonus would be if the formula for the 2 blank cells could ato-populate, as well. I'm certain it is possible, I just cannot seem to figure it out for myself with my rudimentary syntax understanding.

I'd like to take a course or at least acquire a quality instructional book down the road, but cannot right now with these project demands. I'd sure appreciate any advice anyone may be able to offer. I'd provide my existing file, but it is in a pretty butchered work-in-progress state right now, and I've made a couple other changes to the previous version so providing it would be a bit inaccurate, too. I hope this all makes some sense. Let me know any thoughts. I'll sure appreciate it!

Cheers,
WC

Yes, it was too wordy. I apologize, was trying to be extra-descriptive. Now I have cleaned up the file to remove sensitive details and have attached it here to speak for itself.

In a nutshell: I want to be able to add/delete rows/make changes to the Job#/Cost Codes (col. H&I) on the "Crew&Codes" sheet and have these changes/row additions auto-change on that same job list on the "Shift total" page and the daily pages (3 exist in this file, will be 14). Manpower tracking (v3. sample).xlsx