VBA to create formula references and values in Sheet2 that either reference or are derived from Sheet1

[frisbee]

I hope someone is willing to assist me with a macro that needs to allow the user to selected a single cell in column "C" (Item #) in "Sheet1", the macro will then create a new row on "Sheet2" one line above the last used row and fill in the cells as follows:

Create formulas in columns "A" ("Description") & "B" ("Item #") in "Sheet2" that have formulas that references those values from "Sheet1".

Then create a formula in column "E" ("Gross Income") in "Sheet2".

And lastly fill in a value in column "G" ("Sugg. Retail Price") in "Sheet2" from the value in column "F" ("Sugg. Retail Price") of "Sheet1".

Thanks so much in advance.