Tracking Sheet / Pivot Table Refresh / Fill Formulas

Hi All,

I think my problem is pretty straight forward, I have attached my workbooks so you can take a look. This is what I am trying to do.

Open "orders.xls" and Copy everything except for header (row 1) to "tracking.xls" sheet "Input" destination A2 as values.

Fill down formulas I have from "H2:AD2" until last row with data found in Column A.

Refresh Pivot Table on sheet "Summary"

Thx,
Exc4

Also since I will never change the formulas, is there a way to store them in VBA and with Worksheet_change each time column A is changed to call a sub that fills down the formulas I have written in worksheet "input"? That way I dont have to worry if I by mistake delete them or alter them, and the sub can paste my formulas as values!