printing selected pages in one worksheet while working in another
 

i have three worksheets in my workbook
the first contains information that is transposed onto the other two using a
lookup formula.
ive labeled the rows in my first sheet stk001-stk999
the information in stk001(row 4) will print on the first page of the second
and third worksheets. is there a way to print the coinciding pages in
worksheets two and three by selecting the row in sheet one?
any ideas would be greatly appreciated