Use the INDIRECT() function:

Let's say we have six sheets:
Sheet1
Sheet2
Sheet3
Sheet4
Sheet5
Sheet6

In A1 enter:
=INDIRECT("Sheet"&ROW()&"!H6") and copy down thru A6


--
Gary's Student


"barry" wrote:

i have created a log on worksheet 1 that references cell h6 on ws2,
ws3,ws4...... and i want to be able to fill down in a series but the fill
handle only fills down the same worksheet so i have type the ws# each time.
how can i fill down easily