excel 2016

I need to send out a request for information from a large number of people, The questions are the same - "Name", "mailing", "address", "city", and "zip" - - it can either be in a word document or as a excel spreadsheet.  once I get the information back, I will then need to consolidate the information into one single spread sheet. I have excel 2016 and i have been playing with consiladte but i overwrites the existing data fields.  how can i get this so that it will put all the new info onto it's own line?
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Michal ZiembaIT AdministratorCommented:
Have you considered to use Microsoft Office 365 Forms? All you need to do is to create a simple survey for users to fill in with a nice form. And what you get from it is an online excel spreadsheet which is filled with data along it is entered by users. They can enter data at the same time, and there is no risk that the data will be overwritten - every set of entries (name, mailing, etc.) is saved in a separate row.
Give it a try at https://forms.office.com/
CeredAuthor Commented:
we don't have microsoft forms.  would be a great solution tho.
Michal ZiembaIT AdministratorCommented:
You might consider to use it for this purpose from a trial O365 subsription if you are not the O365 tenant yet.
It seems this might be huge time and effort saver for you in this particular case.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Zeth LarssonCommented:
On what format do you get the information back from from each person?
Do you get one XL-file from each person?
Michal ZiembaIT AdministratorCommented:
Since there was no other solution this seems to be the best one.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.