Macro to fill in a static form with formulas using the next row of a reference sheet

[Lmel58]

Hi Gurus,
I am fairly new to macros in t hat its been a while since i have worked with them and have forgotten alot....
I have a dynamic form in worksheet "Part Form" and a data dump from an app in worksheet "App Data import"
I have formulas in the static cells fill in the "Answers" from the app Data import that all reference the same row number but am looking to get a macro if possible whereby if I run the macro it tells the formulas to reference the next row down in all of the formulas.
I hope this makes sense and I apologise if I haven't included all things required.

L