Automatically copy to new rows to new rows as raw data is added on another worksheet

Hi everyone,

This is my first time using this forum, and my macro skills are super basic so really hoping someone can help me out with this little problem...

I basically have two worksheets: the first one is called "Residential_Inputs" and it only contains raw data. The first set of data filled starts from F8 and I will keep adding new rows and columns over the years. Basically, I will be entering raw data to this sheet every quarter.

The second sheet is called "Residential_Calculations" and will consist of one simple calculation which is: Residential_Inputs F8/Residential_Inputs E8.

Because the number of rows in my "Residential_Inputs" sheet will keep changing as I enter raw data every quarter, I do not want to have to copy/paste the formula or link the data everytime I enter new data.

Is there a way I can use a macro so that everytime I enter raw data into a new row in the "Residential_Inputs" sheet that formula is automatically entered into a new row in the "Residential_Calculations" sheet?

Would appreciate any help I can get on this! Thanks!!!