Okay, I have 3 sheets in my workbook (sheet 1, sheet 2, sheet 3 for ease of use.

Sheet 1: is generated by a form. So every time the form is submitted a new row is added

Sheet 2: is the calulation sheet, it takes values from the last submitted and puts them into this sheet to calculate values that will fill the sheet 3.

Sheet 3: will have a new row created everytime the form is submitted. This sheet cannot be dynamic like sheet 2 will be, it needs to simply copy the values. It will copy the name, timestamp, and name 2 from sheet one, and then take value 1, value 2, and value 3 from sheet 2.

I have tried to learn some VBA but seemed whatever i did i couldnt get it to work correctly.

Currently how I am filling the values from Sheet 1 to Sheet 2 is by ='Sheet 1'!E2 through ='Sheet 1'AG2

I am then using those values to calculate 3 values on sheet 2 that are put in cells B85, B86, and B91 on sheet 2. I then need to create a new row in sheet 3 (non-dynamic) to have the values from sheet 1 (A2, B2, C2) and the values from Sheet 2 (B85, B86, B91)

Sorry if that was confusing and thanks a lot for the help