I have been trying to develop a client data input form that is referenced by a printable output form in another sheet. What I am struggling with is how to have my code make changes in the output form based on the cell input in the data entry form. For example, if I want to add a row in the data input form (Cell A17) and that corresponds to adding a row in the output form (Cell A7).

So my question is how can I write a code to create an offset based on active cell (active sheet) to another sheet?