I need a VBA script that will allow me to reference a cell(s) in ALL worksheets automatica

You're very welcome. I really do appreciate your help. This has been HUGE. I've been manually typing these surveys into excel so this is 10000x easier. And I can save for future surveys.

My last question... I've updated the example (see attachment) with comments. Depending how many questions the patient responded to the survey comments may be in different rows. I would like these returned with the other data at the very end.