I need to accumulate the data from 2,000lease + worksheets onto one summary
worksheet. I would like to insert the lease number and use HLOOKUP to
populate the summary sheet. I'm not familiar enough with INDIRECT to put it
in the formula. I copied the following from another community posting and
tried to adjust it for my summary sheet:
=HLOOKUP(A5,INDIRECT($A$5&"!$d$4:$h$104"),2,FALSE)
The worksheets contain 6 number (e.g. 001500).
Can you please help me to write the correct formula to pull each piece of
data from the worksheets' columns D through H to the summary sheet?
Thanks,
Kelly