I'm not entirely sure how to phrase this, but I will give it my best shot.

I have a workbook with 51 sheets. Sheet one is a summary sheet of the other 50 sheets. I have a row with a bunch of cells that have formulas generated to show the information I want shown. There are 50 rows that I want to generate for each sheet. I made the first row and it was a lot of figuring out of the formulas to get it right. Now what I would really love to be able to do is pull the fill handle down and have stuff auto populate adjusting for the change in sheet, but I know that doesn't really work. My next though was to select the row of cells, copy and past into the row below it and change the sheet referenced from 1 to 2 and etc, that is not too terrible I thought. However when doing that I am also offsetting some of the cells referenced in the given sheet. So when I have a formula that is referenced to cell B139 or whatever and I copy and paste it down it now references B140. I was hoping when I copied and pasted it would still reference B139. Is there an option on the past to disable the filling downward of cells? Does this make sense?

It would just really be a pain to regenerate the whole worksheet referencing the whole workbook.

Thanks,
Matt