VBA to loop through cell-defined range and paste table output after each loop.

Hello,

I've attached an example of my problem. Not sure where to start - your help much appreciated in advance!

Table 1 provides a unique ranking (driven from) elsewhere in my model but the cells will be formula based.
Table 2 is what the macro aims to calculate with each loop (see formula in cells). The loop is to start at 1 and go until the value in cell F6.
Table 3 is continually overwritten after each loop, (example output shown depending on cells B6 and G6).

I couldn't find a clear example elsewhere so i really do appreciate your help!

cheers,

m