Add Formula Automatically?

I've attached a zip file of a project that I'm currently working on that I'm hoping could add formulas automatically and create a refresh button.
I've included a description of what I was looking for in the excel file.
Thanks
Nate

"1. In "Item 1" users will copy the columns that they were given in access and paste them in the "PASTE SKU COLUMN" and the quantity's in the "PASTE QTY COULUMN"
2. I would like to know how I could create it so that the rows are automatically added and formulas are also automatically added so it appears as "Item 2"
3. How do I create a refresh button so that when a user is done they can hit "REFRESH" and the tool will go back to the origional look of "Item 1"
Thanks in advance for all your help!
Nate"