Front page for mobile device that can save to separate tab

I want to create a survey form to record the condition of doors within a property.
At the moment this is using an excel sheet that consists of 80 'pages' (formated print areas) each page is exactly the same and on the same work sheet.

What I would like to do is have one page on one worksheet which has a 'save' button on it. Each time the save button is selected a new row is populated on another worksheet in the same document.

So if each door is the same you wild change the reference number on the page and click save, then change the ref and click save. Creating a work sheet with all the details from each save but in an excel format.

The reason for this is to have a document that is more user friendly in that you wouldn't have to select duplicate items each time and it weeks also lend it's self more to a mobile device like a tablet.

I'm familiar with Excel formulas but not macros.

Any suggestions of this is possible in excel?

Deleted pending compliance with moderators request.

Ok My Friend this is quite simple.

We are talking about 80 doors in a property. So 80 rows.

I would suggest that you use a multipage userform one page for each type of door.

Please provide a spreadsheet detailing the types of door you have and the questions relating to each door

something simple, then I will create someting for you.

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

How many types of doors, finishes, and optional fittings do you have,