What I did right now is work with the offset formula as i mentioned earlier:

=match("Grand total";Dashboard2!Q:Q;0)+1 --> name value "CI_Start"
=match("End critical";Dashboard2!Q:Q;0)-1 --> name value "CI_End"

=offset(Dashboard2!$P$1;CI_Start;0;CI_End-CI_Start;4) --> name range "Selection"

Then, in VBA:

Range("Selection").Select
Selection.Insert Shift:=xlDown, CopyOrigin:=xlFormatFromLeftOrAbove <<x50>>

Then, to prune back excessive rows, I created something similar to this but in reverse