Moving dynamic data to a specific row despite row being filtered

Hi,

Maybe biting off a bit too much here however this is the problem

I have one main sheet in the example, it is sheet 1

I have then have an input sheet where a variety of people place information. (Input)

there is a number of companies all of whom has paid a certain amount and some companies a multiple of times.

These entries need in the turnover section need to be added up and sent over to sheet one in the correct section

The problems I am having:

The categories are filtered so they are constantly changing position

and the Input page is constantly updated

I am hoping there is a formula or a bit of VBA that maybe able to help.

Many Thanks,

Daniel1234

In E2, this will show the sum of all the rows that match the 3 criteria:

=SUMPRODUCT((Input!$B$7:$B$200=$A2)*(Input!$C$7:$C$200=$B2)*(Input!$D$7:$D$200=$C2)*Input!$E$7:$E$200)
...copy that down

For D2, this will get the top date in the list that matches, presumably the most recent, yes?
=INDEX(Input!$F$7:$F$200, MATCH(Sheet1!A2&Sheet1!B2&Sheet1!C2, INDEX(Input!$B$7:$B$200&Input!$C$7:$C$200&Input!$D$7:$D$200, 0), 0))