Macro to copy formulas down based on row count from another sheet

Hello,

I need to tweek a spreadsheet so that I can hand it off to someone who is a little less experienced in excel. One of the enhancements that I would like to do is create a macro to copy a row of formulas down instead of having to copy the same formula down. The formulas are on Sheet 1 and they are linking to a pivot chart on tab called MMS pivot. The rowcount on MMS Pivot is variable. I need a macro that will look at the number of rows on MMS Pivot tab and copy the formula down (on sheet 1) the appropriate number of rows. The MMS Pivot table has columns A:U & sheet 1 has formulas from column A:AC

Again, I'm very new to VBA so everything still looks like Greek to me. I'll try to not ask too many dumb questions.

Thanks! Kevin