Automatically Changing a cell value and Record another cell value

Hi, I am a little new in using VBA, but i have experiences in using C and Matlab. I am currently working on a project using excel worksheet.

What I have in my work sheet is a section full of calculations and formulas. I need to input a list of numbers (1-10) in a specific cell in the this section. (Lets say A1). Then my results will generate at D1,D2 & D3.

How to set up an VBA that will allow me to automatically input the numbers (1-10) into the input (A1 cell), and record their corresponding D1, D2, D3 in another table.

Thank you for helping!!!