If you make the titles in Column A consistent or add a column in Workforce that categorizes each item in Column A as under the items in Column A of the Job Group sheet.. then you can use formula like this in E6:

=SUMIF('Workforce Analysis'!$A:$A,MID($A6,FIND(" ",$A6)+1,255),'Workforce Analysis'!F:F)

copied down and across the Male section,

Then in M6 use:

=SUMIF('Workforce Analysis'!$A:$A,MID($A6,FIND(" ",$A6)+1,255),'Workforce Analysis'!O:O)

copied down and across Female section.