In the end you will have a separate workbook for each person involved.
You could (would have to) develop a macro or other code to process the
information received into a common spreadsheet and/or common resource