I have 2 sheets in a workbook. Sheet1 contains 25 rows of data. Sheet2
contains a column of 5 cells that are the basis for a large calculation
within that sheet. Today I'm manually loading up the 5 cells and then
running a macro to print out the results.

I want a routine that loops through the 25 rows of Sheet1 and for each row,
copies 5 of the cells (in that row) into the appropriate cells in Sheet2 and
then run the print macro. I'd like to run this routine from Sheet2 if that
matters.

The data in Sheet1 is in rows and the destination of the values in Sheet2 is
in a column