Create an Excel Workbook that compiles results on final worksheet

I am trying to figure out how to configure a Workbook that follows the following sequence:

Sheet 1 - Compiles information entered through a form. First set of info is in Row 2, next set is entered in Row 3, etc.
Sheet 2 - Takes info from Sheet 1 to perform calculations
Sheet 3 - A different calculator that takes info from Sheet 1 to perform calculations
Sheet 4 - Compiles ID information from Sheet 1, results from Sheet 2 and Sheet 3, and helps to make a decision based on this information.

My principal question is how to format the cells to end up on the same rows in Sheets 1 and 4. Sheets 2 and 3 only need the info to perform the calculations.

Thank you for your assistance!

It would be much easier if you were to attach a sample file. Please see the yellow/gold banner at the top of the page.

I've included a sample of the type of Workbook I am working on. In the end, I would like for the Workbook to help me make decisions based on results of the calculations. Thank you!

Hmm, lots of questions - Based on the simplified version of the workbook, it's unclear why you just don't have 1 sheet. You could add the calculations onto the same row, and Sheet 4 is the same as sheet 1 with the calculations added.

You say,

I would like for the Workbook to help me make decisions based on results of the calculations

How do you want it to help you?

Are the calculations on sheet 2 and 3 always in the same spot, meaning are they always 2 and 3 rows below the address?

My principal question is how to format the cells to end up on the same rows in Sheets 1 and 4

Format what cells?

Hi Greg!

Thanks for the assistance!

Sheets 2 and 3 are each pretty complicated calculators. Each one analyzes the figures entered into Sheet 1 and returns the results onto Sheet 4. I will then combine the results from Sheets 2 and 3 onto Sheet 4 to help me come to a decision about the entry made on Sheet 1.

This is being used to analyze Real Estate Properties for if they would be good investment income vehicles. Sheet 2 is a BRRRR Calculator and Sheet 3 is a Cap Rate + other info. Sheet 4 will display the results from Sheet2 and 3 and I will add some more criteria to help me make a decision.

I hope this helps. Thank you!

I still don't know what you want. Do you want to know how to pull the numbers from sheet2 and 3 into sheet 4 using formulas?