So, I'm trying to build an intake form that will let users fill out their information and then automatically grab that data and put it through a "Calculator", where it will then get pushed to a 3rd sheet for printing. The issue i'm running into, is that while I can use =INDEX[Example Item A]1:[Example ItemA]1 to grab the numbers from the first row in that column into a locked row further down and then link the calculator to those cells. This solution does not work (within my knowledge of the INDEX command) for words & checkboxes. This is a problem because the print sheet needs to be able to grab the names and contact email of the most recently submitted row as well. I've tried using INDEX(Match with cross-sheet references but either didn't understand how to adapt it to my usecase, or it doesn't fit it. It seems Match requires something on the destination sheet to match it to, and I don't have a reference since each form entry will be an entirely new person / order.
Example below of what i'm referring to, the entire sheet is over 20 columns of numerical questions I didn't think would be helpful to have added.
I think the ideal solution for my use case would be a way to use INDEX to move every cell from row 1 into this locked row to be referenced out, only because of consistency. But i'm open to any solution.
