Copy formulas in a filtered list & paste as values (visible cells only)

Hi there, I've never known how to do this - in attached sample file, I need to filter column D on "A". That filtered list then contains formulas in each (yellow) row (linked to next worksheet). But I need to be able to copy paste (the visible yellow cells only) as Values - all of them at same time. I know you can easily copy paste visible cells with just one value, or copy paste visible cells with formulas but can't seem to copy a filtered list of formulas as values. I seem to have to do so one row at a time.. surely not?!

Hope this makes sense!

Thanks