Copy formulas but changing only the cell values

I am trying to copy and paste formulas from one worksheet to another but then change only the cell values each time without having to re-type all of the different values. For example: I am copying from the same worksheet. My cell formulas, for example are =('sheet1'!A15) then =('sheet1'!A19) then =('sheet1'!A26) then =('sheet1'!A41)...and so on (they are random). Once copied, I would like to select the entire new worksheet and add a value of 6 to each cell formula, resulting in =('sheet1'!A21) then =('sheet1'!A25) then =('sheet1'!A32) then =('sheet1'!A47), etc... The source, format, and everything else on the page remain the same. I hope there is a way to do this. Thanks for any help. Jim

I probably gave a poor example now that I think about it. The problem is the rows will remain the same, ie: $B$A41 then $B$A55 etc... I want to change them to $B$A47 and $B$A61 etc... I only want to add numbers to the formula. It's a fairly large table and I thought there may be a way to add numbers by a specific value. Thanks for responding.