Google Sheets Array/If Then

I need to create a new tab in Google sheets that will look at the table below and only return a row if there is a non-zero value in a particular column. For example, on the US tab, there would only be two rows, row 3 and row 6, and it would only include the US column. New data is added to/changed on the source sheet daily so it would need to update automatically. Is this possible, and if so, how?

Date Description Amount US Mexico Canada Japan 05/10/21 blue 208.80 2.00
05/06/21 green 220.00 220.00
05/04/21 brown 131.00
05/03/21 black 75.00 22.00
05/06/21 gray 20.00 30.00 27.00 05/06/21 orange 82.00
05/06/21 red 110.00 23.00