How to put 'box' w/variables that will automatically enter into spreadsheet?

I work in Real Estate and want to create a nice workbook that I can submit properties using a standard 'box' with certain variables at the top of the page (i.e., price, size, dimensions, time on market, etc) and then click 'submit' and they're automatically entered into a table?

Then once they're in, I want to be able to compare them. (i.e., compare 1 property with all overs based on size, compare the average price of those w view to those without, etc).

Can anyone provide a simple outline of what I need to do? I can figure out how to use/do anything in excel just not sure what each function is called etc.

Thanks so much.

Creating this "box" you speak of could be possible with a macro, but unfortunately its not something I can do. Yet. Why not simplify things and skip the "box" by entering data in a nice formatted table. Afterwards you can do all sorts of things with the data by sorting it based on criteria, using filters, pivot tables, graphs and functions.

@OP

It sounds like you want a User Form (a VBA existance) to update a table, and then maybe a PivotTable to slice up and explore the table?

@op, will you want to rank these items with a weighted value?

For example lets say they have been approved for $290,000 but could go up to $310,000. So you could create a value that a 330 house has a negative weight & is discounted on the final score etc.

The homeowner is ok with doing a remodel but want to buy & move in, so you add a negative weight to home that need remodeling etc.