How to Automatically Insert Lines between sheets

[tms90]

Ok this may sound a little confusing but i will try to be as precise and clear as possible.

First What I am doing:

I am creating excel spreadsheets for importing bills into Quickbooks.

In sheet 1 i have the data that will actually be imported into quickbooks

In sheet 2 i have the input data that gets linked to sheet 1. The input sheet is just to make the template more user friendly for the person inputting the data.

What i want to do:

I want excel to automatically insert a QB formatted command line in sheet 1 when i add a new item in sheet 2. So when i need to add new items (very frequently i do) i do not have to create a new SPL line on the actual import sheet.

I am curious if there is an easier way to do this which i may have overlooked before i dive into VBA and macros, since I have little experience working with macros it may take me a while to figure out the processes.

Any help or advice would be greatly appreciated.

If my description needs to be clearer please let me know and i can try to attach a sample.

Johns Groceries Import Template.xlsx
Thanks!!

-Troy