Input Output in to Excel using a loop

I want to be able to read a known number of multiple input values from one excel sheet and populate the corresponding multiple outputs in another worksheet Those outputs will be a mix of values and text. To do this I assume I need a programming loop. I have a complex worksheet but can someone show me how to do with this in principal with this simple example ?

G