Update workbook from another using upload button

I need a way of creating a form within a workbook which has multiple boxes to enter data into and for each box that data is entered into it corresponds to cells on another workbook which updates automatically when saved OR with an Update button on the form that forces it to update the 2nd workbook cells.
Example are attached (unable to upload attachments for some reason so see images as examples). The form workbook will be filled and the data needs to be transfered onto the results spread sheet.

Is this possible?

Form.JPGresults.JPG

To attach files, click on 'Go Advanced' and then scroll down and click 'Manage Attachments'.

Still no attachments!!

My apologies. I didn't notice that you placed the attachments in your original post. Try the attached files. I made a few small changes to each file. I protected the Survey Form so that only the cells that need input are accessible and I made a minor change in row 1 of the results workbook. Make sure that both workbooks are open. Make an entry in one of the fields in the Survey Form and exit the cell. The data will be automatically copied to the Results workbook.

You are very welcome.

I'm not sure what you mean. I believe the macro already does that. Currently the macro will add data to the first blank row of Sheet1 of the Results workbook. So the first time you fill in the survey form, the data will be copied to row 4. The second time you complete the survey form, the data will be copied to row 5 and so on. When you say

Then when sheet2 is updated

we're not using any sheet named Sheet2. Could you please clarify? Also you must keep in mind that the way the macro is written, you must make sure that every field in the survey form is filled in every time. There must be no blank fields. If there is a possibility that even one field of the survey form will be blank , I will have to modify the macro. Please let me know.

Sorry if I wasn't clear.
You're right that is what it does. But what I have created are 63 seperate sheets that all relate to a seperate form. Each will be filled in at key times and the data transfered to the results spread sheet. What I want is for Sheet 1 to only update row 4 and sheet 2 to only update row 5 and so on. At the moment if I type a wrong word in one of the cells on sheet1 and press tab then go back to amend it, the results workbook will have 2 entries for both of the words in rows 4 and 5. I need it to be more locked down.
Does this make more sense?

See my attached spread sheets. They are designed that when saved in the same location if you open Forms.xlsm it will open Results.xlsx at the same time.

Try the attached file. You will notice that I removed all the macros in each individual worksheet code module and instead placed one macro in the code module for ThisWorkbook which will apply to all worksheets except "ECP Form". Please note that this macro is based on the current sheet name and sheet codename structure in the Form.xlsm workbook. If this changes in any way, the macro very likely won't work as expected.

My pleasure.

Try the attached file.

Always glad to help out.

Hi Mumps1,

As discussed here are my documents. What is happening is when you click the "Launch Kradle Form" button on the ECP Form tab in the Forms.xlsm document it unhides a tab as desired. By selecting a Site Name from the appropriate drop down at the top of the new unhidden form and pressing enter it renames the tab to the name selected. This then adds a new line to the results sheet and any subsequent information added to the form is also transfered to the same row in the result sheet.
BUT it only lets me do this up to the 8th sheet. As soon as I unhide and amend the 9th sheet and onwards it starts going back to row 4 in the results sheet overwriting the information already entered. I need it to just continue down the results sheet with every sheet unhidden in the form.xlsm.
I have unhidden sheet 8 so test by selecting a Site name. This will create a new row in the results sheet. Then unhide sheet 9 and see that it starts to overwrite previous info in row 4.
Hope this makes sense.

After looking at the Form file, I thought it might be better to simplify it. Rather then having a large number of hidden sheets that you would call up when needed, this version of the workbook has a blank template of the Survey Form which will be copied as needed and then filled out. As it is filled out, the Results sheet will be populated. This eliminates a lot of unnecessary code and also fixes the problem you described. Give it a try and see what you think.

My pleasure.