need paste special value code

Hi,

I'm a newbee and trying to automate an excel spreadsheet. Here's what I have so far:

In one section of the spread sheed I have actual cell references in the cell: like a2 c2 d2 What's important is that each cell has a different letter but they all have the same number. the actual matrix is 20X60.

What I do now is I high light the reference cells and do a find replace all. Each time I do this I increment the cell reference by 1. So in the first example all data is referenceing data in row 2 I do the find and replace and now all the references are for data in row 3.

When I update this my other data is updated with the new results. I then do a copy for that matrix and do a paste special value in a new worksheet.

I repeat the procedure and each time append the data in the new spreadsheet following the last paste special.

I have to go through this procedure about 100 times. Is there anyway to automate this?