How to write VBA, so I can refresh input cell and capture all outputs from each loop

hi, need some help. i attach the file below. try to simplify the question.

assuming i have three worksheets:
1) input: col A has a series of product code (string)
2) calculation: where I want to automatically copy and paste each product code from "input" worksheet into "calculation" cell B4, and through many steps of calculations, return the outputs in cell B8 and B9 (parameters are numeric)
3) output: how to automatically record B8 and B9 from "calculation" sheet to this sheet Row 5 and 6 from each loop? (format of output doesn't really matters)

thanks. Any advice would be helpful.

what's wrong with it?

Many Thanks, i think I figure out how to do that. still new to loop things. ^_^