Macro to loop through rows and strip out duplicated numbers designated by month column

Hi - Thank again for your previous assistance. Wondering if I could pick your brain on a tweak and add on to the same query. How do I tweak the macro so that it uses column D as a loop reference? (Ive also added in some additional columns).

Also, ideally I would like to display 2 seperate tabs as end results. One displaying prepayment numbers in Local Currency (AQ:BS) and another tab with the same data but (AQ:BS) in GBP. The GBP tab is currently translating local ccy into GBP using v-lookups from the FX tab. Is there a more efficent macro that can do this? (20,000 rows so quite a large data tape). Please see attaced file for an idea of the relvant data and end result.

Thanks!