Reference a value from another sheet that might be in a different place each time

[M3K1RKJP]

Hello,

I keep a spreadsheet that I drop some reports in to from a PMS on a daily basis for each day of the month).

I want my main sheet to pick the yellow values as in the extract below. Is this possible? They'll always be in the same column but not the same row and both rows are entitled 'Summary Total' so I don't think vlookup of sumif(s) is possible.

TIA

 

[kvsrinivasamurthy]

How you want display the results in Main sheet.
Data in Sheet4
In Main sheet

=FILTER(Sheet4!C1:C20,Sheet4!A1:A20="Summary Total")

 

[M3K1RKJP]

How you want display the results in Main sheet.
Data in Sheet4
In Main sheet

=FILTER(Sheet4!C1:C20,Sheet4!A1:A20="Summary Total")

Hi, thank you for taking the time to answer.
I need to see the 19.89 and 7.43 separately on different rows in my main sheet e.g.