Usually I am pretty good at using formulas, but this one has me
baffled, I am pretty sure it is possible.

I have two sheets; on the first page I have all my calculations and
variables, one row per item, but multiple columns. On the second
sheet I have how the items should be formatted. I am trying to figure
out a way script it so I can choose a row, and have it fill in the
cells on sheet 2, or choose another row from sheet 1 and have it
recalculate the cells on the sheet 2. In a nutshell sheet 2 is a
template that gets it information form sheet one. The trick is that I
need to be able to choose what rows from the first sheet.