Extract data from table to another

[PsychX]

Hi All,
i have problem with my excel table. I have table(sheet BA11) with almost 4k row and in this table are subtable repeated every 30-36 row. Every subtable has same layout but not same number of row.
I need extract from table 2 value and this is Name and Total. Name alwas start NAME: xxx xxx and his position is A4, A39, A73 etc. and Total was in G30, G35, G99 etc. i need extract this list of name and his total to next table(sheet)

Name xxx xxx 15
Name xxy xxy 11
Name xxz xxz 17

Can me anybody help me? i Can try use index, match, offset but i have always problem with not same numbers of row between values.
Thanks.
Marcel

 

[PsychX]

ok thanks.
i have summing in G30 that was sum from G8:G29, that was ok. I need just copy this sum to next place.
Next table can be on same table on column O (name) and P (sum from G)

N P
A4 G30
A38 G64
etc

that be perfect to me.