Need VBA code to find SAP Key from reference min to max sheet

Dear experts

i have master data with ref sheets like Ref_1,2,3,...etc

i want find SAP KEY from ref's sheet start with min(Reference_2) range of (G2:H3), If concante column G:G match in range get result H:H, once done delete fist 3 row ,bring the next 2 row up. this action get change depends upon ref-sheet
if its Ref_4 delete first 5 row bring up next 3
if its Ref_3 delete first 4 row bring up next 3

loop the action through all sheet once done msg box all sheet done

there is one challenge, if combination order in 1,2 in report data sheet 2,1 need to find exact combination



find the attachment