cycle through data from another sheet

i have what i hope is a simple one:

i have a spreadsheet with row1 headers for all of the data columns, A:AX
all rows under are individual data. the spreadsheet is great, but is horrible to print from
i am hoping to create another sheet that will pull in data into a formatted version of the form
what i need is to dynamically call the data from individual rows at a time
for instance, in the new sheet formatted for printing, i need something like this: NAME: =Sheet1!A2
and the like for all the columns of data for that row.
is there some way to just type a number in the 2nd sheet that would dynamically change all of the formulas?
for instance, changing a cell in the 2nd sheet to "245" would return the value for: NAME: =Sheet1!A245

so basically i just need some way of being able to call up the row of data that i want.

thanks for any help!

the file contains sensitive data, so i have created a mock file with writeup on Sheet2 of the workbook, attached.
thanks!mock.xls

Originally Posted by bebo021999

This may help:
=INDIRECT("Sheet1!A"&G4)
=INDIRECT("Sheet1!B"&G4)
=INDIRECT("Sheet1!C"&G4)
etc...

BEAUTIFULLY SIMPLE! thanks!
do you know if there is a way to create buttons that could incrementally change the value of G4?

Originally Posted by bebo021999

Try with Spin button!

sweet! thanks!