Copy the data from Sheet1 to Sheet2 with random lines

[rolysudest]

I have a worksheet containing two sheets with the same events grouped by lines, the first detailed and the second briefly, only the principal values ​​"extracted" from the first sheet.


Sheet1 - GENERAL (detailed):
Row 287: Event X
Row 278: Event Y
Row 308: Event Z
and so on ...
(I wanted to point out that the numbering of events is random)


Sheet2 - TOTAL (briefly):
Row 9: Event X
Row 10: Event Y
Row 11: Event Z
and so on ...


So there is no numerical matching rows between the same events SHEET 1 and SHEET2, but the events are the same.


Event X from TOTAL sheet takes values from certain cells from the event X from GENERAL sheet, Y from Y, Z from Z and so on.
Very important: Each time the same columns as follows:


E9 from TOTAL has the formula = GENERAL! BH287
F9 from TOTAL has the formula = GENERAL! AD287
G9 from TOTAL has the formula = GENERAL! AJ287
and so on ...


E10 from TOTAL has the formula = GENERAL! BH278
F10 from TOTAL has the formula = GENERAL! AD278
G10 from TOTAL has the formula = GENERAL! AD278
and so on ...


E11 from TOTAL has the formula = GENERAL! BH308
F11 from TOTAL has the formula = GENERAL! AD308
G11 from TOTAL has the formula = GENERAL! AJ308
and so on ...


Every time I create a new event in the TOTAL sheet, I copy the last row (Z for example) and put it under him. But it automatically takes data from the next row of the GENERAL sheet, which i do not need, given those explained above. And I should carefully change the row number in each cell in turn created.
I would be grateful if someone would clarify how and in what way could I "indicate" to the new row from TOTAL to change in all formulas the row number that taked from GENERAL. Means to "say" somehow to the new row what row to take the GENERAL (obviously keeping columns in formulas).




Thank you very much!