Pull dynamic data from a Master Sheet to populate a Different Sheet via form
I have a Master sheet (database) where I have columns A thru HM. I pull a number of different reports from this master sheet and information is added by folks via one of 12 different forms on a daily basis. What I am looking for is this--I have created a form in a new sheet, where a person is able to look for and find their full name, I would like this name to updated dynamically and linked to my Master sheet, the person enters answers two other questions and when they hit submit, it pulls the rest of their demographic information and populates this testing sheet, so that I can run a daily testing report in the format the State requires for daily result submission. I am only looking to pull 11 columns, of my master sheet that would be used to auto populate when the form submission is completed and I would auto populate the rest of the needed columns as that information is static or is the answered questions.
Currently, I pull reports to create testing sheets so that the people can find their name and enter the data and time of the testing done manually; then someone has to manually enter the date and time of the testing into the spreadsheet and then compile this spreadsheet for submission to the State.
I have attempted to link and index, as it is not dynamic and the form wants to populate the information into the master database and not pull information and populate in the testing sheet. Cell linking does not work as the rows are always being added and the row are also alphabetized on a regular basis.
Any assistance that could be provided would be much appreciated.