I'm trying to create a form where I can host on SharePoint, its filled out and submitted, once submitted then sent to an excel sheet, then indexed and sent to a different sheet in that excel file. Is this possible? I just need guidance on if it can be done and a good starting point. Thanks for any assistance!

Oh and I forgot that the excel file is stored on a separate drive and not on SharePoint. I'm not even sure if its possible.