VBA For Editing In Store Data

Currently We enclosed a Workbook (with exiting VBA code) In this workbook 3 sheet exit (Edit, Details, Summary)

In Details Sheet store Detail Entry of Invoice & in Summary Sheet we store all generated Invoice details in summary form

We want new VBA or correction in existing VBA.

My Exiting VBA work following..

When Enter Invoice Number in Edit Sheet (Cell B2) then Display Entered Invoice Data

First Code Find Invoice Number in Summery Sheet if Invoice Number found then Record Display of Selected Invoice

Here we Edit As per our requirement then We Press Y in Edit Sheet Cell C30

If Found C30 "Y" & "Data ok" in E30 then DELETE Selected Invoice Data From SUMMERY & DETAILS SHEETS & COPY THIS EDITED DATA (RANGE A33 TO G33 In Summery Sheet & Range A35 to A60 in Details Sheet)

My Exiting code work perfectly as per above

We want only following thing

Currently when we copy edited data that move to end of sheet We want to Change & same place where data exit previously before edited. Because serial number disturb.

NOTE : in Editing Time is it possible Few Item Delete or Few Item Add