Will someone be able to advise or direct me to the correct place, where I can turn this excel workbook into a user friendly form, and the data to go to an external workbook or tab in another workbook that is dedicated to that specific, once it is submitted?
Based on the channel of information accumulation, I feel you might need multiple forms rather than a single one to do it, for simplicity. At the end, you want your data to be saved on a shared workbook probably.
