Extract Abstract From Detailed Sheet

I have a detailed in which the particulars are entered as shown below.

Sl.No
Name
Amount
Remuneration

1
A
32500.00

40000.00

[code]....

Now the Abstract of the above data is needed to be populated in the next sheet which looks like below.

Sl.No
Name
Amount
Remuneration

1
A
87500.00
6344.00

[code]....

I know if Sl.No, Name, Amount and Remuneration are in same row(as in Sl.No3), this can be done using VLOOKUP. But now can some one give me a formula where in Name, Amount and Remuneration can be populated if they are not in same row(as in Sl.Nos 1 and 2).