You can use this copied down

=INDIRECT("'"&ROWS($A$1:A23)&"'!H2")

no need for absolute references to H2 in this case since INDIRECT
makes it static. You can use any row reference $B$1:B23 etc to
get the 23 here it is important to use absolute reference on the first cell

--


Regards,


Peo Sjoblom

wrote in message
...
There are a number of posts on this subject, but I couldn't find
exactly what I was looking for!

I have a workbook with a number of invoices, all the same format, one
on each worksheet. The worksheets have the same number as the invoice
and are numbered sequentially (35, 36, 37 etc).

I have a summary sheet that has one line per invoice and shows invoice
number, date, total etc. Can I use Fill Down to copy formulae such as
='23'!H$2 so they increment from row to row to ='24'!H$2, ='25'!H$2
etc? If so, how do I go about it?

Thanks in advance!

Chris